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!
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!