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.Corruption is a low possibility, but not impossible.
I think it is much more likely to have been caused by these more common problems:
- an action resulting in unintended consequences, such as executing a delete query with inappropriate parameters. I have done that, and the only thing that saved my bacon was an hourly backup being performed on the network. IT restored the lost data quickly, if not happily.
- linking to the wrong back end and storing some data in one accdb and some in another without realizing it immediately.
I can't give advice on next steps. What you do about it depends on factors unique to your situation. I would recommend NOT deleting any data, regardless of what else you do. Deleting data is an irreversible step.
I would also implement a rigid back up protocol. Hourly or daily, at least.
