Forum Discussion
David_Nelson
May 12, 2023Copper Contributor
all records not visible
I have a small travel company and have trips from 2006-2023 in Access. When I just opened Access, only the trips from 2006-2015 were visible. I tried the "repair and compact database" page: https://...
Tom_van_Stiphout
May 13, 2023Iron Contributor
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.
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_NelsonMay 15, 2023Copper ContributorThanks 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_HepworthMay 15, 2023Silver Contributor
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.
- David_NelsonMay 16, 2023Copper ContributorHave you heard of something like this before? Could a database get corrupted so that some, but not all, data was deleted?
And, going forward if I am not able to find the missing data in any backups, would you recommend that I delete all data and use the old framework (tables, queries, forms) to start a new database?
This is all new to me and I am looking at the best ways forward. I appreciate how you are sharing your experience.