I have what for me is a large database: 1.8 MB on disk, 18345 records. It has no forms at all. It’s just the data sheet and a couple of procedures.
A few days ago, as I was working on it, adding records, Panorama X crashed and quit. I reopened the database and saw that Panorama couldn’t find any of the records I had added that morning. Then Panorama X crashed again and after that, I was unable to open the database anymore.
Restarting the Mac didn’t help, neither did the transfer of the file to a different Mac. I didn’t try anything else but just started over with the last version on Time Machine. Unfortunately, that was the previous day’s last backup as Time Machine had done nothing during the two hours I had worked on the file before it crashed. Sometimes it backs up after less than an hour, sometimes it waits for over two hours. There doesn’t seem to be any way to get it to be more regular, other than manually telling it to “Back Up Now”.
I came here to see if other people had had the same experience and so I tried to open the corrupted database using the Open Data Sheet Only pop-up menu, but it didn’t open either. Anyway, as I mentioned, my database is really nothing more than the data sheet anyway.
Now, I’m saving a copy by hand after about every hour of work.
Does anyone have suggestions about the cause of this corruption? And, more importantly, how to avoid it in the future, other than the repeated saving of a copy of the file while working on it?