Hello,

I have a database that is split, with the front end copied to users
personnel area of our IT system.

Access to records is define by a unique logon which gives them user or admin
or superuser access. User only lets the user see his or her records. Admin
allows for all records in his/her deptparment. Superuser allows all records.

This works well, but having difficulty with some users accessing backend
with comments return "cannot lock file".

How can I set up the network backend permissions, which resides inna public
area of the network, so to allow all access to databse but stop anyone
deleting the back end.

Hope the above is clear.

Thanks.

Martin hopkins

Martin Hopkins wrote:
Give all users read, write, create and delete permissions on the database
folder.

Set up the users as part of a windows group and only allow administrators and
that group to have access to that folder.  This ensures only authorized
people can use the database.  If anyone deletes the file, tell them they'll
be fired.  They'll be more careful but you *can't* prevent them from deleting
the file if you *must* allow them to use it.

Password for CurrentUser()
Adding new users to an Access 2002 DB
How to remove Security from Access 2002
Network ID ans user level security
Lock Users Out