Reserved Error

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.

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?

Quote:

---

Originally Posted by 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?

---

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.

Well done.
Possibly due to Microsoft updates.