Interference and locking

  • Thread starter Thread starter Ilan
  • Start date Start date
I

Ilan

Hello again,
i am still having trouble with my secured database. to
refresh your memories i have read only users, admins, and
full data users. i would like to have the full data
users and admins to be able to edit records while read
onlys are in the file. Right now, i get a message
saying:

"Microsoft Access can't save design changes or save to a
new database object because another user has the file
open. To save your design changes or save to a new
object, you must have exclusive access to the file"

This occurs when a read only user has the file open and
an admin user is trying to save.

What i would like to happen is have the read only users
be able to look at the data without interfering with the
users who are admins.

Any suggestions?

Thank you so much friends,
Ilan
 
You seem to be concerned with full data and admins being able to *edit*
records, however the message you are getting suggests that they are trying
to make *design changes* - that is not the same thing.

If they are going to be making design changes or creating new objects, they
must have exclusive access to the mdb to do so (this has nothing to do with
the read-only users - they'd get the same message if a full data user was
using the mdb).

In recent versions (since 2000) you must have exclusive access to make
design changes.

You should split the database into frontend (all objects except the tables)
and backend (just the tables/relationships). Give each user a copy of the
frontend on their computer, and link it to the backend on the server.

All users will need full permissions on the folder on the server where the
backend is.
 
Back
Top