prevent deletion of database

[Smokie]

I have a database on the network. Other users need to add data and make
reports. Is there a way to protect it was getting deleted? It has already
happend once.

 

[Rick Brandt]

I have a database on the network. Other users need to add data and make
reports. Is there a way to protect it was getting deleted? It has already
happend once.

Nope. If the users need to use the mdb then they will need permissions on the
folder that would allow them to delete it.

You could use a front end/back end setup (something you should be doing anyway)
and keep the back end in a folder that is shared but hidden. Then your users
would have a reasonably difficult time even figuring out what that folder
location is much less finding it and deleting your file. This is "security by
obscurity" which is about the best you can get with data in an mdb file.

 

[smokie]

if I put a password on the database can it be deleted

 

['69 Camaro]

Yes. The database can still be deleted. When file deletions are made, it's
the operating system's security permissions that apply, not Access security
permissions. Anyone authorized to use Microsoft Access in a multi-user
environment has the ability to delete the MDB file. This is one of the
downsides to having a file-based database instead of a client/server
database system.

Rick's suggestion of "security through obscurity" is your best bet. Hide it
from the users' view. And be sure to make plenty of backups.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.