Menu Bar Startup Options via VBA

[TechBoy]

Hello.

Re: Access 2002-SP3
I have some options turned off under "Tools/Startup" area on my
workstation. When I deploy my app to 5 users (who will all have a full
blown version of Access 2002 on their PC's) I would like to disable
some startup options programatically at runtime via VBA.

I am looking for VBA code to turn off these options at application
startup and turn them back on for the user when they shutdown my app:

"Allow Full Menus"
"Allow default Shortcut Menus"
"Allow Built-in Toolbars"
"Allow Toolbar/Menu Changes"
"Use Access Special Key"

Also, without changing the menu bars, is there a way via VBA to disable
only the databasewindow icon (the one that pops the DBWindow container)
at startup, (leaving all other toolbar icons alone) then enable the
databasewindow icon back when my app shuts down?

Any assistance is appreciated.
Thank you.

[Rick Brandt]

TechBoy wrote:

Hello.

Re: Access 2002-SP3
I have some options turned off under "Tools/Startup" area on my
workstation. When I deploy my app to 5 users (who will all have a
full blown version of Access 2002 on their PC's) I would like to
disable some startup options programatically at runtime via VBA.

I am looking for VBA code to turn off these options at application
startup and turn them back on for the user when they shutdown my app:

"Allow Full Menus"
"Allow default Shortcut Menus"
"Allow Built-in Toolbars"
"Allow Toolbar/Menu Changes"
"Use Access Special Key"

This can be done, but as "Startup Options" the code will only affect what
happens "the next time" the file is opened, not what is available in the
current session. Is there some reason you don't just set these properties
BEFORE you distribute?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[TechBoy]

Hi Rick,
Thank you for your reply.

Is there some reason you don't just set these properties

BEFORE you distribute? <<

yes. I don't want the users to be able to go to
Tool/Startup/StartupOptions and click checkboxes to turn all the menus
on and thus be able to get to the DBWindow and jimmy with the data and
possibly corrupt it and/or the table relationships..
My desire to set them via VBA (via an .mde version) inside the app at
startup would prevent the power users from getting to the DBWindow.
This app has some sensitive data in it.