I had an Excel file linked to multiple Access dbs on the network. When a user would run the queries or open the reports that were linked to the linked table, it would "lock" the linked table so that when someone else tried to run the queries or reports, they would receive an error message that the Excel file was open exclusively by another user. Well, after several weeks of trying to create a solve-for, I have done it. I created a make-table query to pull in all the data from the Excel file that runs as part of a macro. I linked all the reports and queries to the new make table, instead of the linked Excel file. Basically, I'm accessing the linked file for a second, taking a snapshot of the data, then putting the data in a "stand alone" table.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
A fix if you receive a 3051 Error
- Thread starter sprite
- Start date
Similar threads
