Create new table query and database corruption?

N

Nicole

My database is corrupt. I've tried compaction and repair and I've tried to
decompile and recompile all without success. Now I want to just create new
tables without the bad records but I can't figure out how to leave the bad
records behind. I can't just delete the records due to the corruption.
There are two bad records with primary key auto numbers 15 and 65535. How'd
that last number get there when there are only 38 records?

Furthermore, why am I experiencing corruption so early on in the game?
Right before the corruption occurred I kept getting this Write Conflict error
when trying to save my work. I have no idea how to begin trouble shooting
this issue.

In addition, I have several backups. One backup dated back to some time in
July seems to be less sickly than more recent ones. However, I'm still
getting an Invalid Argument when scrolling past these two bad records. So,
this leads me to the question: why create the backups if using them is not
going to solve my problems? Could my corruption be in the BE? One thing I
know for sure is that the corruption has something to do with these bad
records. I don't know how the bad records were created, but I want to get
rid of them.

Please help :(

Nicole
 
K

KARL DEWEY

Use an append query with criteria <>15 AND <> 65535 to copy all but
the bad records.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top