Exclusive rights

[Rpettis31]

I have a user of my database that when he is in it it does not allow anyone
else to go into the database. Also when he tries to go into the database it
gives him a message that he does not have exclusive rights to the database if
someone else is in the database?

 

[Jerry Whittle]

All users of the database need Read, Write, Create, and Delete privileges to
the database file(s) AND the folder that the files are in.

It's also possible that user is opening the database exclusively. They
should be starting the database from a shortcut and the target should look
something simple like this:

"P:\Public\Databases\Tables.mdb"

 

[Clifford Bass]

Hi,

Check to see if his default open mode is set to exclusive, and if so,
change it to shared.

Access 2003 and earlier: Tools menu, Options item, Advanced tab,
Default open mode section.
Access 2007: Office button, Access Options button, Advanced item,
Advanced section, Default open mode subsection.

Clifford Bass