Prevent users from deleting database file in shared drive

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access to the database is controlled through user groups and permissions
accessed through shortcuts...but the actual database file sits in a folder on
a shared drive. How can I protect the file to stop people deleting it -
which incidentally has happened - although we take backups so not a total
disaster! I made the file read only but this only provides a warning before
deletion is allowed? Any ideas??

Cheers
Debs
 
Debra said:
Access to the database is controlled through user groups and permissions
accessed through shortcuts...but the actual database file sits in a folder
on
a shared drive. How can I protect the file to stop people deleting it -
which incidentally has happened - although we take backups so not a total
disaster! I made the file read only but this only provides a warning
before
deletion is allowed? Any ideas??

Cheers
Debs
Click to expand...

Remove delete permissions from the mdb file - note, leave delete permissions
in place for the host folder so that the ldb can be deleted. Also note that
you will have to repeat the process if you do a compact/repair since the new
mdb will inherit its permissions from the host folder.

HTH - Keith.
www.keithwilby.com
 
Cheers Keith, I've removed delete permissions from the file and it works.

Thanks again!
Debs
 
Back
Top