I made a database in access, now how I can stop people from deleting the database knowingly or unknowingly. I want people to use it but not to delete database from computer. Is it possible. Awaiting for reply,Thanks.

---

Reply from Richard Rost:

In a nutshell: you can't.

One of the problems with Access alone is that the users need to have rights to the database file and the folder it's in. If they can't write to that folder, then they can't work with records.

I show you how to secure your Access databases as much as possible in my Security Seminar and my Split Database Seminar.

If you need REAL security for your data, however, the only bullet-proof method is to use a database server (like SQL Server). Otherwise, just make sure you have good daily backups and if someone does something they're not supposed to, FIRE THEM. :)