Why is this table generating?

[mlrmlr]

Hello,

I am continually having a problem with my input form. I currently have 5 users entering data into an Access database (2003) form. I am told that the database freezes and does not save the data entered. I noticed that a table called “MSysCompactError” is created when an error occurs. The MSysCompactError table has an ErrorCode column, ErrorDescription column, ErrorRecid column and ErrorTable which lists the error codes and descriptions (see below).

I see the error “Could not find field ‘Description’”. What does this mean? I do not have a field called “Description” in the table.

<ERROR TABLE>
MSysCompactError
ErrorCode ErrorDescription ErrorRecid ErrorTable
-1504 Could not find field 'Description'. fd_log_table
-1504 Could not find field 'Description'. fd_log_table
-1504 Could not find field 'Description'. fd_log_table
-1504 Could not find field 'Description'. fd_log_table
-1504 Could not find field 'Description'. fd_log_table
-1206 Could not find field 'Description'. fd_log_table
<ERROR TABLE>

I would really appreciate some help on this. Thanks.

 

[Remou]

This is a symptom of corruption. This may help:

http://www.granite.ab.ca/access/corruption/symptoms.htm

Have you split your database?

 

[mlrmlr]

Remou,

Yes, the database is split.

Thanks so much for the symptom link. It is so informative. Hopefully I can find a fix to my problem on the site.

Thanks again.