Hi,

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.

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

I looked up the description of the error code numbers and I would really appreciate if one of you experts could interpret my errors.

ErrorCode:
1504 - Null not valid
1206 - Non-db file or corrupted db

Thanks.

MLR

Hi,

Do you get these error messages when the users are entering the data, or when you try to compact the database?

I have the same problem with some of my larger databases and find that when I try to compact I receive this error. It is always that I have run out of space on the shared drive. I copy the database to a larger drive, ie c: or other local drive and compress there, then overwrite the old one with the compressed version. I then archive the compressed version I have on my local drive (Just in case of problems).

My guess is not enough room where the database is located.

Hello Martinrhague,

Thank you for your response.

No, I never receive this table when compressing the database. The table generates when users attempt to add a record to the fd_log_table.

I have the database split and the back-end is located on a server that is generally slow. The server currently has 719MB of free space and the database is 12,616KB.

Do you think that a sluggish server and the current amount of free space is causing the issue?

I appreciate your help and time. :)

MLR