Error: Invalid procedure call or argument (5)? (A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8 WinXp SP2)

Topic

New Reply

I have a Custom Menu Bar, when I select:

Tools, Compact and Repair Database…

It runs:

CommandBars(“Menu Bar”). _
Controls(“Tools”). _
Controls(“Database Utilities”). _
Controls(“Compact and Repair Database…”). _
AccDoDefaultAction

I’m getting the following error:

Microsoft Office Access
Error: Invalid procedure call or argument (5) OK

This same code works OK for years with no messages on a2k thru a2k3 computers

Any thoughts?

Thanks, John

Reply | Quote

Replies

I don’t have Access 2007, but I’d think the error is because it has a ribbon instead of a menu bar.

Reply | Quote

I’m using Custom Menu Bar and running 2007 in what they call legacy mode which eliminates Ribbons and uses the Menu Bar File, Edit, View, Tools… as

per http://office.microsoft.com/en-us/access/HA100365441033.aspx%5B/url%5D which I thank your for.

All the other menu option seem OK

John

Reply | Quote

I hope that someone who has Access 2007 can help you.

Reply | Quote

Is there another way of doing the equivalent of the following in code?

CommandBars(“Menu Bar”). _
Controls(“Tools”). _
Controls(“Database Utilities”). _
Controls(“Compact and Repair Database…”). _
AccDoDefaultAction

Tbanks, John

Reply | Quote