REPAIR & COMPACT

S

steve

i have a mdb backend dbase that has 2 records in a table with strange
characters in most of the fields (squares and what looks like russian text
to me). I have no idea why or how this happened but they are preventing me
from compacting the dbase and will not let me delete or change them to
something normal like english text etc.

when i try to compact/repair it stops 1/2way then crashes. then the dbase
wont open at all and i have to try again with a copy previously made.

Can anyone suggest a fix and prevention?
greatly appreciated!
Steve
 
J

John Vinson

i have a mdb backend dbase that has 2 records in a table with strange
characters in most of the fields (squares and what looks like russian text
to me). I have no idea why or how this happened but they are preventing me
from compacting the dbase and will not let me delete or change them to
something normal like english text etc.

when i try to compact/repair it stops 1/2way then crashes. then the dbase
wont open at all and i have to try again with a copy previously made.

Can anyone suggest a fix and prevention?
greatly appreciated!
Steve
Click to expand...

This database is toast at this point. You can probably salvage most of
it though.

See Tony's FAQ at

http://www.granite.ab.ca/access/corruptmdbs.htm

You'll almost certainly need to create a new, empty database; create
an *empty* copy of this table; and run one or more Append queries
using the Primary Key as criteria to append all the *good* records.
Then, import all the other tables *and any other objects) from the
damaged database.


John W. Vinson[MVP]
 
Top