MSysCompactError: Table

[ImLost]

I did a search and read through the other threads, but I'm not sure if they'll help me or not since this is new to me, so sorry if this is mere duplication. ^_^

I tried to repair and compact one of my databases this morning and then noticed that this table appeared. In it it says -

ErrorCode: -1611
ErrorDescription: Could not find field 'Description'.
ErrorRecid: (not sure - it has a Japanese Kanji character and square in it)
ErrorTable: tblPhoneScreenings

I have no idea what this means, other than the problem is in the phone screenings table. This table doesn't have and never had a Description field, so I don't know what this is referring to.

 

[Mhairi Brown]

same thing happened to me - I'm new to the technical side of databasing and cannot read code, have looked through the forum threads and looked up the error table suggested by Pat Harman, but the code isn't on there - does anyone have any other ideas?

 

[gemma-the-husky]

although Access manages its data by presenting us with a nice list of tables etc, internally who knows what it actually does. There presumably is some corruption identified with the tblPhoneScreenings.

I would open it, and see if there is anything strange in any of the fields. If so delete the bad record, and it may cure the problem.

I had a whole database starting to show unusual errors, after a power out at a site, but it manifested as two corrupt records in one table, and after these were deleted everything was OK again.