I've got a 15000 + record database, 100+ tables, a whole heap of forms, reports and queries to boot.
Yesterday I got a corrupted record. Looked it up in my table and the whole line was replaced with "#error". Not so bad I thought, I'll just delete the record. Nope. OK, so I'll compact and repair. That fixed it... or so I thought. The error was gone, but so was my primary key for that table!!!
That's a nasty one since it took out half of my data entry capabilities for half the morning until I worked out that my key was missing.
Can anyone shed some light on this? How can I prevent it from happening again?
The problem seems to be getting worse. It corrupted by itself four times yesterday. Each time I either had to go into the data file, compact and repair, only to find that in another 15 minutes, the stupid thing did it again. This time so bad that I went into the file, compact and repair and wham.... I get booted out. Not allowing me to compact and repair.
I was fortunate to have a backup taken about 15 minutes before, so no major loss, but that could have been a lot worse!
What are the more typical reasons for corruptions? It hasn't been this bad before, but since I added a new section it just gets worse.
Yes, there is plenty of opportunity for record-lock conflict and database curruption for Autonumber keys in a Multi-User Environment. One thing I have discovered helps is if you create a multi-field key. I have attached an example, both A97 and A2K versions.