Sam:
There's a couple of ways that you can have a report on your network be
dynamically updated:
1.) If all your user's have Office 2000 or greater installed (with the
Office Web Components) you can create a Data Access Page in Access and then
using a text editor change the absolute paths with the resulting htm page
created to relative (network) paths to the database and this page can then
be viewed using a web browser.
2.) If you have a server where you can install a web server (e.g. IIS, Cold
Fusion etc.) then you can use those systems to link to your db and
dynamically query your database and return a web based report even if the
user doesn't have Office web components installed.
3.) You can use the Windows Scripting Host and the Windows Scheduler to set
a time each data to run a script that launches Access, outputs the SNP file
and then moves it to the network location you desire. If you want a very
simplified explanation of how to schedule a report's production, stop by our
web and look in the Code and Design Tips area under reports and you'll find
an example of using WSH to automate printing of a report, which you could
modify to create the SNP and then add the file handline routines provided by
the File System Object available for the Scripting host to move the file
(you can see the fso object in the general tips section under automating
compacting of a database.) If you need more information on these objects
then go to
http://msdn.microsoft.com and look up the File System Object in
the MSDN library.
HTH
