-----Original Message-----
I keeping error code 3799 (Could not find field <name>)
when compacting my database. What does this mean?
.
This means there is some junk in the system that Access is
not handling properly. As I recall, the easiest way to
fix it is to run a Make Table query to dump all of the
(valid) data from the offending table into a new temp
table; delete the table that is causing the problem; do
the compact and repair; and then open it back up and
rename the temp table back to the original name.
Make sure you save a back up copy of the entire .mdb file
before you start this, just in case something goes amiss
in the middle of all this and you have to start the
process over.
Rob
