compact error table

J

JAS1924

Very strange table just appeared in my database...

While working in one of my subforms, I started getting error messages after
typing in one of the fields, something to the effect of "Cannot find Field
(then file pathname). I selected OK, but it kept showing up when I moved to a
new record. I closed down the database, and it seemed to be fine after that.
My records saved, and nothing else seemed to be affected.

Now I see that a table has been created, called "MSysCompactError". It
contains 4 fields:

ErrorCode
ErrorDescription
ErrorRecid
ErrorTable

There are 3 records in the table (they coincide with the three error
messages I received befoe I shut down the database).

Is this how Access tracks errors? Is this normal? Do I need to do anything,
and can I erase this table??

Thanks!!
 
J

Jerry Whittle

It's very, very likely that you have a corrupt database file. Open a new
database file and import all the objects from the old database. If something
refuses to import, that thing is corrupted. If you are lucky everything will
import and the problem goes away.
 
J

JAS1924

Thanks for the quick response. I was able to import everything successfully,
so I guess it's ok. I deleted the error table, hope it's not going to screw
anything up.

Thanks Again!!
 

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