Data Access Pages

[Cleis]

Hi Folks!

I'm about to start a major project that will involve reporting various finance reports out of a DataWarehouse. The DataWarehouse is called Datatracker and if you have any experiance with it you'll know that it has NO reporting capabilities!!! I would like to start a company intranet that will display all the necessary information. As I’m reasonably experienced with Access (since Access 2.0) I would like to use the Data Access Pages in 2000. I’ve reviewed the documentation within Access 2000 help and it seems to be pretty straightforward. But as we all know that isn’t always the case! My questions are:

1. Has anyone developed a similar project using Data Access Pages?
2. Can this format handle MANY hits at the same time?
3. What are the pitfalls of Data Access Pages?
4. Can Data Access Pages handle this type of traffic?
5. Does anyone have a sample application or know of a web site using DAPages?

I should mention that if I decide to go through with this, the application would have its own dedicated server.

This application will serve to report on Vendor, Item & Item Category performance for a company that does $500,000,000 in sales annually.

More than likely, it would have multiple users across the country at any given time viewing the data.

Thank you in advance!

 

[Guest_imported]

I would avoid Data Access Pages and work Directly in ASP. Data access pages require low security options on the client side and also have a number of issues regarding portability. I attempted to use them on a smaller project and had to abandon the idea because of, well, just a whole host of problems. For a large project, working off of a non-access database....you are asking for a lot of very difficult to diagnose problems.