Need help with code behind form

[Noreene Patrick]

I have a db that has only 1 table and 1 form (picker db). That is because we only use it to gather info from pickers and dont want them to be able to do anything but enter data. I have a master db that is used by Managers to import data from pickers db to master db to run reports.

Problem is we have someone that is an Access wannabe and sometimes messes with the code behind the form. The only way they can get behind the form is F11 key. I am afraid that if I take off that option then I cant get into the form myself...

Is there some other way that I can set this up in startup and have a way to get into the design view if I need to?

You can tell that I am a new user
Thanks, Noreene

 

[CEH]

You could split the db... Make their copy of the front end a .mde file.... Keep a copy in .mdb for yourself.

 

[ghudson]

I suggest that you secure your db using Access security with a custom workgroup and user permissions. It is not that hard to do once you understand how to do it.

You could disable the Shift key with my code I posted @ Holding down Shift

This thread will also help you out with more tricks... Hide all Access Toolbars and Menubars

Searching the forum is a great way to discover and learn the answers to your Access programming questions.