Default open mode question

[JHC]

Please excuse me if this is a duplicate question. I am confused about Shared
vs. Exclusive Default open mode.

We have an Access DB/Application on a shared server. User1 opens the
database and sees the Default open mode is set to Shared. User2 then opens
the same database from the same server and sees the Default open mode is set
to Exclusive.

Question 1: Is the Default open mode an attribute of the database or the
Access software?

Question 2: How can we lockout all users when we need to change a table or
form?

 

[Allen Browne]

The actual open mode depends on who opened it first.

In your example, User1 is configured for Shared open, and User2 for
Exclusive. If User1 gets in first is is opened Shared for everyone for that
session. If User2 gets in first, no one else will be able to get in.

If you have not done so, you really need to split this database, so everyone
uses the same back end (MDB containing just the tables), but each one has
their own copy of the front end (queries, forms, etc, and *linked* tables.)

If that's a new concept, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

 

[JHC]

Thanks very much. I will migrate to the FE/BE approach.