Opening Access with Multiple Users

D

Dave

I have a database that is on a network, when one user is
on and another user tries to open the database the
following error appears...

Error Number: '3405'

Returned by 'DAO.Database'

Procedure 'LogonSet' of module 'modCommon'

Message: '......ECN.mdb'; file already in use.

Has anyone encountered this problem or know the cause.
 
M

Mike Labosh

Error Number: '3405'
Returned by 'DAO.Database'

Procedure 'LogonSet' of module 'modCommon'

Message: '......ECN.mdb'; file already in use.

Has anyone encountered this problem or know the cause.
Click to expand...

The first user that opened the database may have it opened exclusively.

To check this, get on that computer and in access, click Tools -> Options
and goto the Advanced tab. You should see an option group or a checkbox
about opening in shared vs exclusive mode. This will likely be different
depending on your version of Access.

If that turned out to be the fix, you should probably look at that setting
on all of the users' computers.
--
Peace & happy computing,

Mike Labosh, MCSD

Feed the children!
Save the whales!
Free the mallocs!
 
Top