Laura said:
I have a db that's to be used by multiple users - I copied the .mdb file
to a
shared site but it seems that only one user can open the db at a time.
Not sure how to handle this so that they can all use it in read-only mode
simultaneously.
All users need pretty much full permissions to the *folder* where the file
resides so that Access can create, modify, and delete the locking file (LDB
file extension) that is required for multi-user operation. If the first
user in cannot create the LDB file then he is effectively opening the file
exclusively.
Now...what you are attempting is "technically" allowed, but many years of
experience by Acess user/developers has shown that having multiple people
use a monolithic Access file at the same time greatly increases the odds
that your file will become corrupted.
What is highly recommended is that the file be split. One file (the back
end) contains only tables and that is the file that is shared on the
network. Separate files (front ends) containing everything except the
tables and instead have links to the tables in the shared back end file are
given to each user to store on their local file system.
