administrator can not open database exclusive

[ron ravilious]

problem: after administrator opens database, changes can
not be made when database is already open by a "new data
user" or a "read only" user. pop up message seen when a
change is attempted is "you do not have exclusive access
to the database at this time. if you proceed to make
changes, you may not be able to save them later".
information: using access 2002. database is shared on a
network. settings are: tools/security/user groups and
permissions/ permission tab... administrator name is
highlighted, "users" picked for list, object type
is "database", open exclusive is checked. other
settings: tools/options/advanced tab... default open mode
is "shared". also, the security wizard was run to set up
original security... in the wizard, open/run permissions
were given to "new data users" and "read only" users.
thank you for your advice.

 

[Graham Mandeno]

Hi Ron

This happens only when you try to make design changes to the database, not
when you are simply reading and writing data.

In general, it is a bad idea to attempt design changes when the database is
being shared, especially by production users. It is very easy to break a
production database by introducing a syntax error or some other problem
which stops the database working.

You should make your design changes in a *copy* of the database, and then,
when everything is compiled and working and everybody else is out, copy your
changed database into the production folder.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.