Corupt Table

D

Dwight

Earlier today I posted a question subject "Replication". I was having
problems getting my databases to syncronize. I have since narrowed the
problem down to a single table that appears to be corputed but I don't why or
with what.

I tried to import the tables into a new database but I get the "MS Access
has encountered an error, and must close" error when it starts to import that
1 table.

I have tried to look through the table to see I can identify a problem. I
can scroll around some, but as I am scrolling right, I get the error again.

I hope someone has a solution to my problem so I can get my databases
syncronized.

Thanks in advance!

Dwight
 
K

KARL DEWEY

I am assuming you have tried the TOOLS menu Database Utility - Compact and
Repair Database.

See if you can copy the structure of the table. Click on the table, copy,
and paste - select Structure Only.

Then try running an append query. You might get most of the data.
 
D

Dwight

I did try the compact and repair database, but I get the same error. I now
further narrowed it to when I bring focus to record 23 in a particular column.

Dwight
 
J

John Vinson

Earlier today I posted a question subject "Replication". I was having
problems getting my databases to syncronize. I have since narrowed the
problem down to a single table that appears to be corputed but I don't why or
with what.

I tried to import the tables into a new database but I get the "MS Access
has encountered an error, and must close" error when it starts to import that
1 table.

I have tried to look through the table to see I can identify a problem. I
can scroll around some, but as I am scrolling right, I get the error again.

I hope someone has a solution to my problem so I can get my databases
syncronized.

Thanks in advance!

Dwight
Click to expand...

Check out Tony Toews' Corruption FAQ:

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


John W. Vinson[MVP]
 
J

John Vinson

I did try the compact and repair database, but I get the same error. I now
further narrowed it to when I bring focus to record 23 in a particular column.
Click to expand...

You may be able to create a new database - a new .mdb file, this one
is toast and will be discarded at the end of this process!

Create this table, design mode only, no data; use File... Get External
Data... Import to import everything else.

Link to the damaged table and run one or more Append queries to
migrate all BUT the 23rd record into the new table. Use criteria on
the table's Primary Key to select "around" the damaged record. That
record must be reentered manually, it's gone.

When this is done, check that there aren't any more such records,
delete the old database, compact and repair.

John W. Vinson[MVP]
 
Top