Protecting the Data

[YoelBenYossef]

Hi there,
I wrote a database with a front end form. On startup it opens to the form with no problem. I'm unfortunately worried that someone may hold down the shift key while opening the db and altering the data. I've tried putting a password on the database, but then the user needs the pw to access the form itself. Is it possible to protect just the data?

Thanks
Eric

 

[Crowley16]

access security is not particularly great, however there are a few things you can do.

you can convert your db to a .mde to hide the code behind the db, you can disable the access special keys, i.e. shift, Alt + F11 in Tools > Options, you can use a security file..

--------------------
Procrastinate Now!

 

[YoelBenYossef]

None of those stop a user from holding the shift key down when booting to stop a user from altering the data, which is my primary concern. I've split the DB in two parts the front end and back end but they're still connected and easy to access.

Eric