I have a product I've been selling for 10 years to address this issue.
However I have let the software
get kinda old. In general Access shouldn't be used for anything web-based,
however my solution runs one instance of
access on the server and uses a simple COM component to accept report
requests from your web page.
I never used DAP functionality only regular web functionality like asp or
asp.net (usually against sql server), however I did use
my own product at my old full time job (to replace the $100,000 system we
were going to buy (Business Objects).
Had about 1000 users and 500 reports a day and it worked fine at those
levels.
I would consider my solution a low end solution, which lets you use Access
as the report writer.
I would recommend:
- buy the source code of my product and tweak it a bit (a line or two needs
to be changed for Access2007)
- copy the concept of my product and write one on your own
or
- move to something like sql server reporting services
There are other high end tools:
- business Objects
- Cognos
- Actuate
- Microstratgey
a few others
and other low end:
- active reports
- crystal (yuch)
a few others.
HTH,
Mark
RPT Software
http://www.rptsoftware.com
