Reserved Error

[DBinPhilly]

I am getting a reserved error on an append query.
the message:

Reserved Error<item> there is no message for this error (Error 3000)

I am assuming this is a data corruption error. Am I right? If so, any ideas how to identify the corrupt records? This is loading a very large table from several other tables. It's a program that's been in service for about 20 years, so there is lots of data.

[OBP]

Reserved usually applies to table field names and not normally data.
I would create a recordset of the query or preferably the table and run through the data with a record counter and see what record(s) it stops on.
Have you tried resetting the query to a simple query rather than a append query?

[DBinPhilly]

Reserved usually applies to table field names and not normally data.
I would create a recordset of the query or preferably the table and run through the data with a record counter and see what record(s) it stops on.
Have you tried resetting the query to a simple query rather than a append query?

I solved the problem in the middle of the night by doing essentially what you suggest. The record causing the error message was one from 12/8/2008. Why it decided to corrupt in 2020 is beyond me.

[OBP]

Well done.
Possibly due to Microsoft updates.