Forum Discussion
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://...
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.
- 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!!
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.
- Have 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.
