I am using Version
22.214.171.124 126.96.36.199 on an iMac with OS 10.15.6. I use Base to store my work activities. I have been using this system for over a year with no problem but all of the information I entered yesterday has vanished. As far as I’m aware this has never happened to me before. I use these records for invoicing so it’s a bit of a nightmare.
I have various linked tables (one that holds the overall record for the day, one with the individual tasks I’ve completed, another for tasks to do and so on). I add to these tables using a form which has information for the day on the main form plus two separate subform tables (Done and To Do).
I was adding records throughout the day and often click back and forward between days to get calculated fields to update and to make sure everything I’ve entered has saved. Nothing appeared to disappear during the day. It all looked to be working fine as usual. At the end of the day I closed the form, clicked save on the database and closed it. This morning, when I looked, none of the records I created yesterday are in any of the tables.
The database is stored on Dropbox so I looked at the version history. There was only one version from yesterday, which was 18:35 (that was when I clicked Save). The records normally save regardless of whether I actually click Save on the database. - No longer relevant since database is now stored locally.
I restored the version from yesterday and that was identical to the one I opened this morning, with all yesterday’s records missing.
Is there any way to retrieve them or at least to prevent this happening again in the future?
Edit: This has happened again three weeks after following the advice to move my database to a local drive. The records have vanished from the main copy of my database and from the backup. This is not a dropbox problem since I no longer use dropbox for this database. I would like to know exactly where the records are stored since I suspect it may not be within the .odb file.