Compress and Repair Damaged Database

owain · June 26th, 2003, 06:56 AM

When you need to repair a damaged or corrupted database, in which order should you compress and repair?

For example, should the compress be done first followed by the repair, or is it the other way round, or should you compress, repair and then compress again?

Regards
Owain Williams

owain · June 26th, 2003, 07:28 AM

I forgot to mention, it is an Access 97 database that I am accessing through Microsoft Jet 3.51

Regards
Owain Williams

Dataman · June 26th, 2003, 08:18 AM

Make a back up and then try it both ways. If that doesn't work, there are other applications that will repair an MDB.

Regards,
Mike

owain · June 30th, 2003, 04:45 AM

Thanks for you suggestions. I was wondering if you or anyone could provide some more information on applications that repair Jet databases. The client with the damaged database does not have Access installed, so he can not use the Compact and Repair Database facility.

Regards
Owain Williams

Jeff Mason · June 30th, 2003, 05:55 AM

Owain,

See my off-topic reply to your off-topic post in the SQL Language forum. :D

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com