Prevent users from deleting database file in shared drive

[Debra]

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

 

[Keith Wilby]

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

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

 

[Debra]

Cheers Keith, I've removed delete permissions from the file and it works.

Thanks again!
Debs

 

[Keith Wilby]

Cheers Keith, I've removed delete permissions from the file and it works.

Thanks again!
Debs

No Probs, glad to help.

Keith.