Access database problem - using several instances
Hi guys
I have built a database in access and need to add some basic security by disabling the SHIFT key and several menu options - I know it's not perfect but it will do! I'm using code such as the following to disable the menus and options
VB Code:
CommandBars("Form View Subform Control").Enabled = False
CommandBars("Form Datasheet").Enabled = False
CommandBars("Menu Bar").Controls("&File").Enabled = False
However, if the user opens another instance of Access, the new instance has the same settings my database i.e the same toolbars and menus are available etc.
My question is: Is there anyway I can get the new instance to open up with default or the old settings?
Thanks
Pobo