Protect Form and Table

[Icy]

Hello, could anyone show me the best way and quick way to protect the Form
and fields at the Table from authorized change. I try to hide the table and
put a password on the form, however, it's still too risky. User still can
unhidden the table and change the data without going through the Form. Any
assistance would be greatly appreciated.

 

[boblarson]

If you

1. convert the final product to an MDE file so the user can't get to design
changes on the form.

2. go into Startup options and remove the default menus and add your own
custom ones.

EITHER 3 OR 4 should be done, but both don't need to be if one is done.
3. Make sure the forms don't have the close button (red X) enabled, or
change the code to close the app when it is used.

4. Make sure the database window display is unchecked in startup options.

With those done, the user will not be able to get to your table.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Rick Brandt]

If you

1. convert the final product to an MDE file so the user can't get to
design changes on the form.

2. go into Startup options and remove the default menus and add your
own custom ones.

EITHER 3 OR 4 should be done, but both don't need to be if one is
done.
3. Make sure the forms don't have the close button (red X) enabled, or
change the code to close the app when it is used.

4. Make sure the database window display is unchecked in startup
options.

With those done, the user will not be able to get to your table.

Unless they press F11
Or
Hold shift while opening the file
Or
Link to the tables from another file
Or
....

 

[Icy]

Please suggest a best way, really appreciated it.

 

[boblarson]

Probably use Access security

Here's some info on that. Take a look at the Security paper by Jack
MacDonald.

http://www.geocities.com/jacksonmacd/


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.