Trouble opening database for multiple users.

Darren26

Registered User.
Local time
Today, 17:36
Joined
Jul 12, 2005
Messages
18
We have an access Database stored on a server that until now was only ever accessed by the one user. Now more users need to access it at the same time. However when a second user trys to open the database the error message "File Already in use appears". I did not create this database so have no idea how it was set up. I think it may have something to do with being opened up exclusively. Is there anyway around this by creating a short cut or changing any kind of propertties?
 
Darren26 said:
We have an access Database stored on a server that until now was only ever accessed by the one user. Now more users need to access it at the same time. However when a second user trys to open the database the error message "File Already in use appears". I did not create this database so have no idea how it was set up. I think it may have something to do with being opened up exclusively. Is there anyway around this by creating a short cut or changing any kind of propertties?

Go to tools---Options--->Advanced Tab--select default open mode to be shared instead of exclusive.
 
Also ensure all users have full file permissions [read/edit/delete] to the directory where the db is located.
 

Users who are viewing this thread

Back
Top Bottom