Good day everyone. I have a newly constructed Access 2007 database that links to 2 SQL DBs and has multiple reports, etc.
It works perfectly from my desktop but when I load it to a folder on a network share and attempt to run it form there, it just does not display the correct data (or any data) on the reports.
The I can view the records on the SQL databases and have added the network share as a trusted location to Access 2007.
Any ideas how to make this work?