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?
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?
