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?

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JHC" <(E-Mail Removed)> wrote in message
news:CE2DCA79-7B33-49D9-894E-(E-Mail Removed)...
> 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?

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

"Allen Browne" wrote:

> 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
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "JHC" <(E-Mail Removed)> wrote in message
> news:CE2DCA79-7B33-49D9-894E-(E-Mail Removed)...
> > 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?
>
>