How can i use a report from Access 97

I was wondering if there is a way I can use a report from Access 97 to print a certificate using SQL Server and being displayed in ASP as well?We use Access 97 to create monthly reports and have them available for the Web. When we run the report we save it in a format called Snapshot, there is a viewer that can be used in an ASP to view Snapshot reports. They look just like they do in Access.

Here is an example of the ASP code:

<OBJECT ID="SnapshotViewer" WIDTH=100% HEIGHT=97%
CODEBASE="/apps/CabFiles/Snapview.ocx"
CLASSID="CLSID:F0E42D60-368C-11D0-AD81-00A0C90DC8D9">
<PARAM NAME="_ExtentX" VALUE="16722">
<PARAM NAME="_ExtentY" VALUE="11774">
<PARAM NAME="_Version" VALUE="65536">
<PARAM NAME="SnapshotPath" VALUE="<%=reportName%>">
<PARAM NAME="Zoom" VALUE="0">
<PARAM NAME="AllowContextMenu" VALUE="-1">
<PARAM NAME="ShowNavigationButtons" VALUE="-1">
</OBJECT>


We only do this for monthly reports, I've created a Perl script that runs after hours to generate these reports. I'm not to sure of performance and concurrency if I had these reports generated on demand by the front-end.|||but you really should be using Access 2002 with Access Data Projects.

they are a lot faster for reporting than traditonal MDB.