Is there a way to automate the export to snapshot process?

[hopper]

I need to have an Access report that is viewable and printable from an ASP page. I also need the report to be dynamic so each time a user ran the report Access would re-export the report to a snapshot.

Any help or comments would be greatly appreciated.

Thanks,
Hopper

 

[danvlas]

Well, Access is not designed to do that...but a workaround would be to store the requests in a table (doable from ASP page). An Access form with a TimerInterval set to 500 or 1000 could check for unhandled requests and output the required snapshot. Of course, one at a time, so you need to pair the ASP request with the corresponding report.

But this requires Access to be running and the form to be loaded.
Not a very good solution, but I doubt there is a better one with snapshots - AFAIK they are produced by Access only.

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[mtcrawford]

I think this might help.

http://4guysfromrolla.com/webtech/042600-1.shtml