Compact db in access 2007

[Guest]

I don't see compact and repair database in ribbon menu.
Access 2007 down't have compacat repair database?
Is it not need?

Thanks
jcp

 

[Stefan Hoffmann]

hi Jose,

I don't see compact and repair database in ribbon menu.
Access 2007 down't have compacat repair database?
Is it not need?

You will find it under the Office Button, Administration.


mfG
--> stefan <--

 

[Guest]

Thanks Stefan, is there. I hate ribbon, lol

I convert a acc2003 database (ADP) to acc2007. It opens with classic menu
and in this menu, I use compact and repair database (the same tool in acc2003
tools\compact repair)
I click in compact and reapir and I receive the following error:
The method you tried to invoke on an object failed.

Do you have an idea what's happen?
In acc2003 it works fine.

Thanks

 

[Guest]

You might try compiling the application. Normally I do that when I can't
figure out some cryptic Access error. With the VB window open, the offending
line is usually highlighted for me at compile-time.

Dennis