I have a spreadsheet in our company's network drive utilized by 10-20 users, linked to an Access database through an OLEDB connection by several pivot tables and charts. Recently, the database has been getting held up when certain computers refresh this connection. Since these connections are through the ACE 12 connection, the temporary Access file (.laacdb) is showing up, often preventing some computers from successfully adding and saving to the database.

One solution to preventing the temporary locking file is to utilize the ODBC query instead of the OLEDB. Unfortunately, I have searched the web for how to do this without completely recreating all the charts and pivot tables with no promising results. I might mention that this just became a problem a month ago, considering this spreadsheet has been utilized for about a year. Not sure if our IT dept. may have made some unwanted changes with the network, but I am struggling with this.

I have created a backup database that is being connected to just for dumping data in unison with the original database, however, I do not have the spreadsheets refreshing from this connection as to prevent it from getting hung up as well. Therefore, the backup database, containing all the data is transferred manually to the original database, containing only partial data, weekly. If anyone has any suggestions I would be very grateful. Thank you.