Compact DB on Exit

[bostonfrog]

Because I changed the default menu in Tools | Startup for my current database project, and I changed the Menu bar to my own, I am not able to use Tools | Options and check off "compact database on exit". I want to be able to perform this function on exiting, but now I can't access these options as I can't display the default Menu Bar to do it. Will I need to create a new db with the default Menu Bar and re-import all the objects? Any work-arounds through VB code?

DoCmd.RunCommand acCmdCompactDatabase

won't work.
-- Michel

 

[jrbarnett]

Hi,

To get to the startup options to let you change the menu back - which you can then set the option and then change it back:

1. Load your database.
2. Press Ctrl G to open the debug window
3. Type
DoCmd.RunCommand acCmdStartupOptions <RETURN>
4. Change the appropriate options.

John