ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel from Access/File Sharing (https://www.excelbanter.com/excel-programming/301610-excel-access-file-sharing.html)

LarryP[_2_]

Excel from Access/File Sharing
 
Here's one that has me stumped. I have an Access
application that is linked to numerous Excel source files
out on our company network. The app is used by 80+ users
(each has his own copy of the "front end" Access file).
When one user launches a query that uses a particular
Excel file, no other user can run the same query until the
first guy is done. Setting the source files to Shared
does NOT fix the problem. Anybody have any ideas on how I
can solve this dilemma? (I'm also going to post this on
the Access Newsgroup.)


All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com