calling menu bar controls

[legendv]

I want a cmd button on a form that lets the user "compact and Repair" the database.
The menu's have been removed.
There is a hidden menu, called "Developer" which is only accessible thru a password protected form, that has the menu option "Compact and Repair Database..."

Here's what I have: (in a module)

Public Sub CompactDB()
Commandbars("Developer").Controls("Compact and Repair Database...").accDoDefaultAction
End Sub

The menubar is labeled Developer and Compactandrepairdatabase is listed in the first pull down

Any suggestions?

 

[Autoeng]

There is a sample db on www.rogersaccesslibrary.com that shows you how to compact.

Fixed it now.


Autoeng

 

[legendv]

invalid URL - do you have a copy of that sample db you could email me?