Forum Discussion
question about access microsoft 365
i was using my access database yesterday and i entered data via form in one of my tables. those entries are missing. is there a way to look back at yesterday's table to find the entries that are missing. I also have backblaze backup but that is not coming up - so easier to just find a temp file from yesterday if you can help me. Thanks.
NancyLWein I was thinking about this some more.
It is odd that the backup system seems to have failed at the same time you lost previously entered data. Is it possible something else might have gone wrong?
I am sorry - i solved my own problem. the table was not sorted correctly - i actually found those entries from yesterday and then got it working. I have had a persistent problem however that is worrisome. I cannot do the compact repair function at all - it keeps telling me that "file is in use" - I liked to do this function periodically. can't anymore.....
NancyLWeinbesides the excellent information that George provided, I implement simple auditing in my application. I add a "Created On" field to all of my tables. I set the default value to Date(). Access then automatically keeps track of every record that I create. These fields do not need to be displayed on forms but they can be. I also sort records on these fields.
As for backing up my app, I have three USB drives next to my computer that I copy my application to every couple of days. I alternate between them just in case one goes belly up.
NancyLWein "...yesterday's table ..."
That's not the way it works. If you created a back up, then that back up should be available somewhere. Unfortunately, it sounds like your backup system also failed. "... backblaze backup but that is not coming up ..."
There is no "temp file" for Access accdbs, sorry.
