You can write a web page to use instead of the Access report,
or you can set up Access as a server to write report snapshots
to a file when you click on a link
or you can run all of your reports to snapshots, and link
to them,
or you can set up a link to create a Terminal Services
Session when you click (requires Terminal Services licences
on your server)
or you can replace all of your reports with reports
from SQL Server Report Services
......
Saving all your reports to snapshots works if you don't
have to update the reports very often.
Terminals Services works if you want full control of
the database, but may not work through all firewalls.
Setting up Access as a report server is possible, but
not recommended, and quite a lot of work. You need to
write a program/script to call access and generate
the report. You need to have a little experience
with web pages (enough to call com objects or executables),
a little experience with script programming, and
a enough experience with Access to know how to call
reports from a comm object or from the command line.
......
Bottom line, unless you know what you are doing, probably
too difficult.
(david)