REPAIR & COMPACT

[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

 

[Joseph Meehan]

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

It indicates that you have some corrupt data. Are they in a memo type
field?

You can try creating a new table by copying the one you have and
indicate structure only when asked. Then attempt to copy the data to the
new table using an append query.

 

[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

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]