Disabling and security

ryetee

Registered User.
Local time
Today, 08:27
Joined
Jul 30, 2013
Messages
952
I have an application that I am about to deploy.
I know for a fact that users like to 'play around' and if they can use anything other than the forms in the design they will.

I'd like to disable as much as I can from access to tables to disable the (access) X in the top corner.

I've spent ages googling and I can't find a definitive answer. If I disable the navigation pane and displaying menus etc in options then a Savvy user can just go into options and enable them again. This method would work for me if that was possible as I can customise the ribbon as well so only the print ribbon is displayed.

I have found a method which gets rid of the ribbon but also stops the user getting into the options by using DoCmd.ShowToolbar "Ribbon", acToolbarNo but this also disable the printer ribbon which is useful.

My ideal solution would be to drive all of this through VBA so I can lock things down for production but not for development.

Can someone point me in the right direction?
 
Their is a lot of info on this site and if you Google it.
 
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
Hide tables.
Setup Access Security or roll out your own.

Good Luck!
 
Hide tables.
Setup Access Security or roll out your own.

Good Luck!

Thanks!
Think I'll go for DoCmd.ShowToolbar "Ribbon", acToolbarNo and tell the user to get used to right clicking to print the reports!
 
Hi

See this site as personalizing ribbons.

http://www.ribbons-access.com

To disable the custom ribbons, just hold down the Shift key at startup.

Use the ACCDR extension to block access structure. When you want to change the project, return to ACCDB.
 
Last edited:
I put some suggestions on your Tables topic on the same problem. :mad:
 

Users who are viewing this thread

Back
Top Bottom