DataBase - 2007 Access Reports On the Web

Asked By Arturo

07-Nov-09 08:00 AM

Since the DAP functionality was dropped in 2007, what is the best tool to
publish Access 2007 reports to the web? Or, can you? I know those that were
doing this with 2003 just did not quit. What action did you take to replace
the process?

Thanks for your help.

07-Nov-09 04:42 PM

I have a product I have been selling for 10 years to address this issue.
However I have let the software
get kinda old.  In general Access should not 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