|
| View All Microsoft Access Reports Posts Ask A New Question |
|
2007 Access Reports On the Web |
Arturo posted on Saturday, November 07, 2009 8: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. |
 |
|
| |
|
|
I have a product I have been selling for 10 years to address this issue. |
Mark Andrews posted on Saturday, November 07, 2009 4: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 |
 |
|
|
|
|
| Previous Microsoft Access Reports conversation. |