I have an AutoExec Macro that opens a Form. The form has 3 buttons, Add Data, Edit Data and View Item Rates. It looks like this:
I want to be able to Hide all the tool bars, menus etc to prevent users from changing the layout, data entries etc. So effectively they can only see whats displayed in the picture. If they click Edit Data button, which is password protected, I want the database to then display the Access Toolbars as normal, providing they had entered the right password of course.
Is this a good way to provide security to my database or should I be trying something else? And how do i go about this?
Thanks