disappeared customers

Unfortunately, there are multiple possible explanations for data being unavailable to you when you look for it.

Some of those possible reasons include

• Accidental deletion by you or someone else who uses the database.
  • Perhaps someone thought they were making a backup and archiving data or something like that.
  • Perhaps someone deleted an accdb thinking it was older and not the current one.
• Restoration of an old, old backup without those records over the top of the newer accdb.
• Corruption in the accdb.
• Accidentally opening an old backup copy of the accdb instead of the one you thought you were opening.

It's highly unlikely that the records simply disappeared without some intervention by a user, or a mishap on your part or the part of someone else who uses the database.

I would start by doing a due diligence search to verify that you are now looking at the correct copy of the accdb. Make sure you or someone else didn't move files around for you inappropriately.

Verify with other users -- if there are any -- that no one else did something wrong, i.e. that no one accidently deleted records.

Make sure the accdb is not corrupted, i.e. that you can open it and browse all of the records still in it and that forms and reports work properly.

If I had to guess, and it would be a guess, I'd suspect you are actually not looking at the most recently working accdb, but an older copy that somehow found it's way into your path.

Hi randy beams

Thank you for reaching out to Microsoft Q&A Forum and sharing your experience.

Please first verify that you are working in the correct database file, not a backup or older copy. You may consider these checks to locate the missing customers without re-entering them:

1, Check the base table

• Open the Navigation Pane and open the actual customer table directly in Datasheet View.
• Then sort the date field: select the drop‑down on the date column header and choose Sort Newest to Oldest.
• If the 2020–2023 records appear in the table but not in your form, the data is not lost, the form/query is restricting what is shown.

2, Check for active filters

Open the form you normally use and look at the Status Bar. if it shows Filtered, go to the Home tab in the Ribbon and click "Toggle Filter" (or "Advanced" > "Clear All Filters") to reveal the hidden rows.

3, Review query logic

• If your form’s Record Source is a query, open that query in Design View and check date criteria on the date field.
• Join types: if the query joins to another table using an INNER JOIN, customers without matching related records can be hidden.

4, Check linked tables if the database is split

• Go to External Data > Linked Table Manager, select the linked tables, and use Refresh to update the links.

Please let me know how things go on your side as your update can also assist others in the community who may be facing the same issue.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

i use access to do service for customers had 5000 plus in computer 365 office / access and i cant find anything after 01/31/2020 to 2024 how can i find these customers without resubmitting them