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:
This did not help.
Are the other solutions for this problem?
thank you
- Tom_van_StiphoutSteel ContributorWhen 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.- David_NelsonCopper 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_HepworthSilver 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.
- George_HepworthSilver Contributor
Look at the most recent backup of the accdb prior to this incident. Does it have the missing records?
Are you sure, as a matter of fact, that you are actually looking at the most recent copy of the accdb and not one from a few years ago?
- David_NelsonCopper Contributor
Thanks for your reply. I am sure that I am opening the most recent database and not one from a few years back. I had this same problem a few months ago, and the issue resolved itself a few days later. Now the problem is back.
Do you have any other ideas?
thanks
- George_HepworthSilver ContributorNot really. There are too many things that can go wrong. Ranging from
Some one "helping to clean up" the database by removing records to linking to the wrong back end, to sorting and filtering problems.