Opening the Database Window

[MossleyMike]

I have an database that is secured to keep those pesky users out (disabling <F11> and all the other "stuff" - however there is an Admin option (passwords etc) - and I wondered if anyone knew of a way to open the database window via some fancy code behind a button. Having looked at AllowSpecialKeys and the like, it seems possible "next time the db is opened" but I can't see any way of opening the window "instantly"....or am I missing something ?

(May Frith forgive me, but our site is still running Access 97 )

Any help would be appreciated..

Mike

 

[Guus2005]

When you use the macro AutoKeys you can open the database window using a different keystroke e.g. <ctrl>F12
Macro:AutoKeys
Macroname: ^{F12}
Action: selectobject
objecttype: Table.
In database window:Yes

Enjoy!

HTH

 

[MossleyMike]

Tend to avoid Macros, so "AutoKeys" appears to have passed me by It works a treat though - many thanks.

 

[Guus2005]

AutoExec and AutoKeys, the only macro's i use.