multiple users in a secured database

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

Ilan

hello.

i have a secured database in access 2003 with the
following groups: admin, read-only, full data users. i
have a small office and would like my read-only users to
be able to view the information while full data users
update it. is this possible? right now, i tried it but i
get a message saying that a full data user cannot save
changes because a read only user is in the database. any
suggestions.

thank you.
Ilan
 
Ilan said:
hello.

i have a secured database in access 2003 with the
following groups: admin, read-only, full data users. i
have a small office and would like my read-only users to
be able to view the information while full data users
update it. is this possible? right now, i tried it but i
get a message saying that a full data user cannot save
changes because a read only user is in the database. any
suggestions.
Click to expand...

If you are creating read-only users with your security settings you cannot
also give them only read-only access to the file and the folder where the
file resides.

ALL users need full permission to the file and to the folder where the file
resides so that a locking file (LDB) can be properly managed by Access. If
a user does not have these rights and they are the first to open the file
Access will give them exclusive access to the file since an LDB cannot be
created thus locking all other users out.
 
any suggestions on how i can make it so admins can go and
edit the data while read onlys can read the data and not
interfere with the people updating the data?

thanks,
Ilan
 
You have already implemented security; the issue now is related to windows
security.

*All* users of the mdb require full windows permissions on the folder where
the mdb is.
 
Back
Top