Securing the back end of the database

[Martin Hopkins]

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

 

[Granny Spitz via AccessMonster.com]

How can I set up the network backend permissions

Give all users read, write, create and delete permissions on the database
folder.

so to allow all access to databse but stop anyone
deleting the back end.

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.