Disable F11

[Gemma Khan]

Hi
I am making one invoice database and I am using Access 2007 I want to hide my Tables, Queries, Forms, Macros from other users actually I want to disable F11 Command. I want to implement security measures in My invoice DB. I am very thankful if u help me in this matter.
Thanks in advance.

 

[boblarson]

Go to the Office Button > Access Options > Current Database

and uncheck USE ACCESS SPECIAL KEYS.

 

[Galaxiom]

http://www.access-programmers.co.uk/forums/showthread.php?t=57429

The other thing worth mentioning is the /runtime switch which forces the program to be limited to the runtime mode even when a user has Access installed. It is a good thing to do anyway so that all users get the same interface.

The switch can be used in the shortcut to the database. The FE Updater program includes a runtime switch option in the ini file so it is easy to make sure users always get runtime.

Sure it is potentially easily defeated in the simple case but it does completely remove the in your face temptation. There are also easy ways to harden this enforcement.

At startup test to find if the program is using runtime. If it isn't then shut it down immediately. This is a one hit solution that doesn't require constant monitoring for keystrokes.

One crude way to test for runtime is try to do something like open the Navigation Window. If it doesn't throw an error then it is running in the full version. I expect there are more elegant tests.

You can also test for the user in this error trap and don't exit when it is someone authorised to edit.

 

[boblarson]

And in Access 2007 you can rename the ACCDB or ACCDE file to ACCDR which then will run in runtime mode without using a switch.

 

[Gemma Khan]

Thank you so much Mr. Boblarson
But the problem is still there I need secure way for example I uncheck this button but when others users use that invoice data base and they check this button again they can view all tables, queries, macros. Is there any secure way is available that I can view all things and others can’t.
Thanks

 

[boblarson]

Thank you so much Mr. Boblarson
But the problem is still there I need secure way for example I uncheck this button but when others users use that invoice data base and they check this button again they can view all tables, queries, macros. Is there any secure way is available that I can view all things and others can’t.
Thanks

You uncheck the Show Nav Pane and also do a search here for DisableBypassKey.