Access 2003

[yanzhang]

Hi everyone,

I have a question here and need your help.

I have a Access application linked to another Access database. The database recently keeps corrupted. After repair and compact, I got a MsysCompactError table. The table has one record:

ErrorCode: -1003
ErrorDescription: Could not find field 'Description',
ErroRrecid: (two square boxes, unrecognized letters),
ErrorTable: Comments.

I opened the organically table, found the first records has XXXX, XXXXXXX like characters.

Can anyone tells me what does this "-1003" means and what should I do?

Thank you.

[r035198x]

Hi everyone,

I have a question here and need your help.

I have a Access application linked to another Access database. The database recently keeps corrupted. After repair and compact, I got a MsysCompactError table. The table has one record:

ErrorCode: -1003
ErrorDescription: Could not find field 'Description',
ErroRrecid: (two square boxes, unrecognized letters),
ErrorTable: Comments.

I opened the organically table, found the first records has XXXX, XXXXXXX like characters.

Can anyone tells me what does this "-1003" means and what should I do?

Thank you.

Moved to acces forum.
P.S Welcome to TSDN.

[Rabbit]

Hi everyone,

I have a question here and need your help.

I have a Access application linked to another Access database. The database recently keeps corrupted. After repair and compact, I got a MsysCompactError table. The table has one record:

ErrorCode: -1003
ErrorDescription: Could not find field 'Description',
ErroRrecid: (two square boxes, unrecognized letters),
ErrorTable: Comments.

I opened the organically table, found the first records has XXXX, XXXXXXX like characters.

Can anyone tells me what does this "-1003" means and what should I do?

Thank you.

It sounds like somewhere, (in your code, in your form properties, in your control properties, in your macros, etc.) it's looking for a field named description but the field doesn't exist, either because it was mispelled or someone typed the wrong thing. Try compiling the code if you have any. If that doesn't bring up the problem then you'll need to start looking through the database starting with the table Comments and anything that uses that table.