By using the Jet Compact Utility, I got the database fixed. The Jet utility also failed to compact, but the Jet utility creates an error table which tells you which table and record is causing the error. I deleted the bad record and the database compacted. I then re-entered the bad record so that the data would not be lost.

I want to thank all of you who contribute to this forum. I come here and research a question or problem and learn so much.

Lawson