Linked Excel tables opened exclusively

T

tedmi

Why can't Excel linked tables be opened by multiple users? The error message
is that the table is already opened exclusively by another user. Access
options are set to open tables for shared use. I realize that Excel does not
have locking mechanisms for guarding against simultaneous updates, but then
linked Excel tables are opened in non-updatable mode. Any workarounds?
The database in Access 2000 format, Excel tables are 2002, Access front ends
2002 and 2007.
 
G

Golfinray

My users don't have issues with that because my database is split and the
tables are on the backend on the server, as are the Excel files. Do you have
the database split?
 
K

Klatuu

Having your database split has nothing to do with linking to Excel files.
The excel file needs to be set to share.
 
T

tedmi

Yes, the db is split. FE on clients, XL tables on server. Spreadsheets still
get opened exclusivley.
 
T

tedmi

Thanks Klatuu, that did it.
--
TedMi

Klatuu said:
Having your database split has nothing to do with linking to Excel files.
The excel file needs to be set to share.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Backup difficulty "Opened Exclusively" message 3
Ghost references to deleted tables in a back end database (Access2000 XP) 5
"Opened exclusively or need permissions" 3
Opened exclusively by another user error 0
Error 3051 Already opened exclusively 0
Forms use linked tables and have multiple users 3
"The workgroup information file is missing or opened exclusively by another user" ARRRRGH! 1
Linked Tables Error - "File Already in Use" 5

Top