[AccessD] Using Access for Reports w/an ASP app?

Susan Harkins ssharkins at bellsouth.net
Mon Mar 22 13:24:11 CST 2004


So far, the main differences I've run across are:

1.	The Snapshot Viewer control is a much simpler technique. You don't
need any real expertise with Access or SV to use it. Generating a web-ready
report with Access is fairly easy, but you have to know what you're doing --
even if you use the ui.
2.	 The XML feature generates an actual page which means everytime you
have to update the report, you have to update the actual Web page. With the
SV, you just save the new .snp file to the appropriate Web folder. You don't
have to actually update the page with the XML code for the new report. Now,
there may be a way around that one, but I don't know what it is besides
automation, which kind of negates the need for the SV technique in the first
place.
3.	The SV gives you an exact copy -- can't get that with XML. 

This isn't a recommendation for SV and against XML by any means. It's just a
coincidence that I happen to be writing about the SV technique and I had to
think through the advantages/disadvantages -- just didn't want to miss
anything if I could help it. 

Susan H. 

Honestly don't know Susan. To be quite frank, I have never used either.
It's very simple to have Access 'export' a report, to a file, which is then
'redirected' through ASP to the user.  The system I built was put in place
due to the 'prompts' that the reports were giving, which were no problem on
the local LAN, where the users had direct access with Access, but for remote
users, those reports took forever, and Terminal Server was getting bogged
down (not too mention they were having printing problems).

Quite frankly, I like snapshot files better then any other format, simply
because I find that it keeps the 'formatting' closer to the actual report
(in my experience).  But I have never used the 'snapshot Viewer control'.





More information about the AccessD mailing list