Repairing Access MDB files (different ways available ?)

Zorallin

Delphi Developer

Tue, 24 Sep 2002 03:00:00 GMT

Repairing Access MDB files (different ways available ?)

Ok, we all know about using the DAO and ODBC methods
to run the Jet "repair" and "compact" functions of the Jet
engine to repair Access database files (MDBs), but....

Has anyone found a tool that can extract the data (tables
at least) or repair the MDB files *without* using the MS
provided tools ?

Reason for the question should be obvious......the "usual"
method doesn't always work......
*** Can't repair/compact from ODBC Administrator
*** Can't repair from DAO application written for task
*** Can't repair/rebuild from MS-Access (Office 95 Ed).
*** Can read/write data but corrupts as time goes by....

MDAC v2.1.1.xxxx *was* installed.
MDAC v2.1.2.xxxx was overinstalled and problem went away.

Fine, problem solved......this time. But for a longer term
solution I need a tool (or library/VCL/whatever) that can
repair MDB files (v2,v3,v4 types).

Any thoughts anyone ?

TIA.

Wood

Delphi Developer

Tue, 24 Sep 2002 03:00:00 GMT

Re:Repairing Access MDB files (different ways available ?)

I had a problem once where several records were corrupted in a table and it
wouldn't allow Access to repair them or compact the database. I wrote a DAO
routine to copy records one at a time, skipping any that were corrupt, to a
new table, then delete the old table and rename the new one. Everything
worked fine after that though I lost about 3 records. You could try doing
the same thing in your case.

Woody

Quote

"Zorallin" <measysSPAM...@powerup.com.au> wrote in message

news:8cjhdc$3vd6@bornews.borland.com...

Quote

> Ok, we all know about using the DAO and ODBC methods
> to run the Jet "repair" and "compact" functions of the Jet
> engine to repair Access database files (MDBs), but....

> Has anyone found a tool that can extract the data (tables
> at least) or repair the MDB files *without* using the MS
> provided tools ?

> Reason for the question should be obvious......the "usual"
> method doesn't always work......
> *** Can't repair/compact from ODBC Administrator
> *** Can't repair from DAO application written for task
> *** Can't repair/rebuild from MS-Access (Office 95 Ed).
> *** Can read/write data but corrupts as time goes by....

> MDAC v2.1.1.xxxx *was* installed.
> MDAC v2.1.2.xxxx was overinstalled and problem went away.

> Fine, problem solved......this time. But for a longer term
> solution I need a tool (or library/VCL/whatever) that can
> repair MDB files (v2,v3,v4 types).

> Any thoughts anyone ?

> TIA.

Other Threads

1. How to compact/repair Access 2000 .mdb file

2. compacting/repairing Access mdb

3. Repair Access MDB

4. Can′t repair an .MDB file with JetComp utility

5. Compact Repair mdb file from Delphi 2nd post

6. Query using tables in different .mdb files

7. Different ways of setting text..

8. dBase-tables - display fields in different ways

9. dBASE-tables - display fields in different ways

10. How to repair an MDB with ADO