Over-riding Startup Options

[taiwai94]

Hello,


I maintain and develop an access database at work. To prevent user tampering of this database, in the [Tools]->[Startup] options, I have disabled all tool bars, menus, etc. However, I want to have a macro-driven button that will over-ride this. If the authorised admin user is in the database, then I would like to have a button that once pressed all the menus and tool bars will reappear allowing modifying of forms/queries etc and all the usual forms, tables, reports etc stuff. Does anyone know how this can be done. I have a feeling its a job for VB but I have no real knowledge of VB other than some basic code I have seen on the internet.

 

[mp9]

You can easily over-ride this just by holding the Shift key down before you start the DB (unless you've set the AllowBypassKey property to False).

 

[taiwai94]

Hi mp9,


I realise holding down the Shift key over-rides all options at startup but I mean while in the middle of the database. A button that you can press that re-enables all toolbars and menus while you are already in the database.

 

[BuilderSpec]

do a search in the help for "startup" , there is a code example on how to do what you need.

Hope this helps!

Regards

BuilderSpec

 

[taiwai94]

BuilderSpec,


I have tried searching but the results I get aren't quite what I'm looking for. Does anyone know how to do this?

Regards,

Taiwai94

 

[PHV]

DoCmd.RunCommand acCmdStartupProperties

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheTomCat]

I don't know about a button for "In the middle of the database", but what about this:

I have the Shift ByPass key Disabled. I have an Admin button on my switchboard. When you click on the Admin button, it asks you for a Password (of your choosing). You then exit the database and reopen with the Shift ByPass key. Then re-clicking the Admin button Disables the shift ByPass key again.






Thomas Bailey
a/k/a TomCat

http://www.reportcop.com

 

[AccessGuruCarl]

Hello,

Create a new form, and password protect it.

Then create a few buttons and paste the code below.

'Disable the Menu Bar
DoCmd.ShowToolbar "Menu Bar", acToolbarNo

'Enable the Menu Bar
DoCmd.ShowToolbar "Menu Bar", acToolbarYes

'Hide the Database Window
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

'Enable the Database Window
DoCmd.SelectObject acTable, , True

I have this in greater detail but cannot locate at the moment. Let me know if you need further assistance.

AccessGuruCarl
Programmers helping programmers
you can't find a better site.