Can't Compact&Repair - corrupt table (help!)

[Guest]

I am having trouble with corrupt tables. I have tracked the problem down to
one of the back-end databases (to
which tables are linked in the front end and the crashing Union query runs
on). It's tblSupport on the RLR_SUPPORT_INFOTERRA.mdb database. This table
seems to be corrupt. When I try a compact & repair on the DB, it crashes. If
I try to select all -> copy the data in this table, it crashes. If I try an
export, it crashes. There is a record with #DELETED in each field, that I
delete every time but always comes back. I really can't figure out a way to
clean up this table!

Any help is much appreciated.
Andy

 

[Nikos Yannacopoulos]

Andy,

Make a new .mdb and try to import everything from the seemingly corrupt
back end. If it works, you will have anew, clean copy of it.

HTH,
Nikos

 

[Guest]

The only way I have found, is to copy the table structure, then use and
append query to insert all the records except the one that is corupted. Then
rename the tables and correct any relationships, and then do a compact and
repair.