Results 1 to 2 of 2
  1. #1
    MAM8433 is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    5

    Does reserved code -3087 mean corruption?

    Hello,



    I'm trying to make the most of a 3-day weekend and hope I can get a definitive answer. I don't know what my next steps are and would like to proceed with development if it's not corrupted.

    Problem: I am developing a database and have 2 three-field queries that are giving me fits. When the first field contains the expression
    CaseStatusSummary: Sum(IIf((Left([rssid],1)="L") And ([lasampletype]>1),1,0))

    or one like that, I get a popup: "Reserved error (-3087); there is no message for this error." However, when I rearrange the query and position this calculated variable to be the second of 3 fields, it works and I get values that I expected.

    Is my database corrupted when I have done the following:
    1. tried compact and repair
    2. tried decompiling the old databse
    3. checked my back up which also has the same issues
    4. Imported everything except these troublesome queries into a new database.
    5. These queries are tied to my main table. In the new database, I created a whole new main table from scratch and I renamed the old main table.

    I hope to find out that this is a "feature" and not corruption. If it is corrupted, what are my options? Recreate everything from scratch? Interesting, I have a 3rd query that has a simpler count expression (there is no "and" clause) and it runs no matter what the calculated field's position is in the query. Thanks in advance. I hope you can help.

  2. #2
    khalid's Avatar
    khalid is offline MS-Access Developer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2010
    Location
    Kuwait
    Posts
    244
    If you want to know how to find your corrupted records? then there is a post?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Data Corruption
    By Pilotwings_64 in forum Access
    Replies: 10
    Last Post: 06-24-2011, 04:25 AM
  2. Corruption nightmare
    By Remster in forum Access
    Replies: 4
    Last Post: 03-25-2011, 06:40 AM
  3. Reserved error (-3703) help!
    By infinite26 in forum Access
    Replies: 3
    Last Post: 02-02-2011, 10:55 AM
  4. Reserved Error -1517
    By Rick West in forum Queries
    Replies: 5
    Last Post: 12-10-2009, 02:12 PM
  5. Data Corruption?
    By tdalber in forum Access
    Replies: 2
    Last Post: 02-03-2009, 04:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums