Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
Access GroupsView
Access Activexcontrol
Access Adp SQL Server
Access Dataaccess Pages
Access
Access Devtoolkits
Access Externaldata
Access Forms
Access Formscoding
Access Gettingstarted
Access Macros
Access Modulesdaovisual Basica
Access Modulesdaovisual Basica Ado
Access Multiuser
Access Queries
Access Replication
Access Reports
Access Security
Access Setupconfig
Access Tablesdbdesign
Access Modulescoding

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Apps
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

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.
reply

 

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
reply


Previous Microsoft Access Reports conversation.