Repair Access 2000 database in VB6 code? 1

[custsoft]

Now and then my Access 2000 file is corrupted and I have to run the repair utility in Access 2000. Is there a way to do that in VB6 code? I did see a posting that said to use repairdatabase(databasename) but what is that? What error code do you check for when you get the unrecognized database format? 3343? Thanks for any help. Joe

 

[custsoft]

Yes, I do understand. It looks like the compactdatabase will accomplish the fix. I thought that ADO would have a specific error number for the unrecognized database format but I will just try the compactdatabase when the program first opens the database and an error occurs. Thanks for all of your help. Joe.