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 mi...
Forum Discussion
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.