Consulting

Results 1 to 4 of 4

Thread: Reserved Error

  1. #1

    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.

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    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?

  3. #3
    Quote Originally Posted by OBP View Post
    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.

  4. #4
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Well done.
    Possibly due to Microsoft updates.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •