Preventing Deletion

[matthewnsarah07]

I've currently got a database whihc collates staff holiday requests. At the moment it is backed up daily by our main IT dept. Because of the way our network is set up its difficult or at least causes access problems if I alter file permissions.

My question is, is there anyway from inside the database itself that I can stop anyone from being able to press the delete key and wipe the whole file?

Thanks for your help

 

[boblarson]

Nope, unfortunately that is a risk that is there that can't be eliminated because users have to have delete rights to the folder that the database is in and therefore can delete the entire file if they want to, or accidentally.

There's nothing you can do within the file itself to keep that from happening. Just make sure that you keep good backups and can restore them if necessary.

 

[matthewnsarah07]

I thought this might be the case. Backups it is then!

Thanks