Repair DBthrough VBA

[Riamor]

Hi I want to repair several databases through VBA codes. Is there a way I can pass the database file, and repair it? Thanks

[ajetrumpet]

there is a COMPACTREPAIR action in the database library

[Riamor]

Can you be more specific? How do I call it through code? Thanks

[ajetrumpet]

try something like:

dim db as dao.database

set db = currentdb

db.compactrepair 

[Riamor]

There is no command like that. Anyone able to help me out here, with the actual code?

[ajetrumpet]

There is no command like that. Anyone able to help me out here, with the actual code?

it takes a little bit of exploration:

application.compactrepair

[Riamor]

Thanks. It works fine for me in Access 2003. However, just found out the client I'm doing this for has Access 2000. And of course, application.compactrepair doesn't work from 2000! Do you know what the code was back then? There's always something!