Write Protect DB With Password

P

PC User

Is is possible to prevent someone from accidently overwriting my
current database file with a file of a previous version by using a
write protection with a password?

Thanks,

PC
 
N

NicoleDBS

Do you have any security such as work groups? This will allow only certain
user access to editing options.
Open the database that you want to help protect.
On the Tools menu, click Security, and then click User-Level Security Wizard.
Follow the directions in the wizard dialog boxes.
Make sure to keep the names and user ids in a secure place you may need them
later and access only gives them to once.

Also there are ways to split the database so that the actual files and
tables in are inaccessable to others. As in people only see the end user
product.
Splitting requires making mde files.
 
K

Klatuu

Splitting does not require making mde files.
Splitting is always a good idea.
The backend should remain an mdb, but to avoid users either maliciously or
inadvertently making changes to the application, the frontend should be
converted to an mde.

You can keep the casual user out of the back end by applying a database
password, but it only takes a knowledgable use about 10 seconds to crack an
mdb password.
 
P

PC User

Currently I keep backups on multiple USB flash drives, but I'm looking
for other methods. I appreciate all your responses.

PC
 
Top