Forum Discussion

  • When looking for "missing" records, use the simplest approach possible. So don't rely on a report or a form, or a query. All of those can filter out certain records based on query criteria, or filter property settings, or several other ways.
    Rather go directly to the table(s). Make sure they are sorted by PK, and go to the last record. I hope this will alleviate the problem. If they are truly gone: thank goodness you keep good backups.
    • David_Nelson's avatar
      David_Nelson
      Copper Contributor
      Thanks for your reply. Unfortunately, I have been looking in the table that contains the master data. The records seem to have disappeared from here. Strange. And, so far, all of my searches in backups have the same problem. Help!!
      • George_Hepworth's avatar
        George_Hepworth
        Silver Contributor

        David_Nelson 

        What could anyone do to help? We don't have access to the accdb in question. We don't know what caused the records to be deleted, and even if we did, there's not much to be done without a backup.

         

        I am sorry.

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor

    David_Nelson 

     

    Look at the most recent backup of the accdb prior to this incident. Does it have the missing records?

     

    Are you sure, as a matter of fact, that you are actually looking at the most recent copy of the accdb and not one from a few years ago?

     

     

    • David_Nelson's avatar
      David_Nelson
      Copper Contributor

      George_Hepworth 

      Thanks for your reply. I am sure that I am opening the most recent database and not one from a few years back. I had this same problem a few months ago, and the issue resolved itself a few days later. Now the problem is back.

      Do you have any other ideas?

      thanks

      • George_Hepworth's avatar
        George_Hepworth
        Silver Contributor
        Not really. There are too many things that can go wrong. Ranging from
        Some one "helping to clean up" the database by removing records to linking to the wrong back end, to sorting and filtering problems.

Resources