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://...
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.
- Thanks for the sage advice. I will look into what might have happened. During COVID, I did not open the database for a year or so, and when I opened it, all the data was not there. I must have done something I had not intended. I appreciate all your help and ideas.