Had my first database corruption

[munkee]

All,

Had my first database corruption today which produced the following error when entering the database from the front end.

Unrecognized database format 'k:etc... path'

I was in the database at the time with around 3 other users where I was prompted with a object not found type error (can not remember exactly).

Anyway I am using the AutoFE updater and have locked everyone out at the moment just awaiting one user to exit the database so I can run a compact and repair. I did a direct copy and paste of the back end and I have found that the error disappears when I load up the back end and select to try and repair it.

However my question is if I create another copy would I be able to track down the corruption?

I dont want to just do a compact and repair and fix the issue when I havent fixed the root cause which may be something wrong in my code/network/tables etc which caused the corruption in the first place.

[TheSmileyCoder]

The times I have had corrupted items they have been caused by:
Network load failure. The network drive had a process which completely used all the resources of the drive, causing everything to just "stop". It didn't really disconnect, yet Ctrl-Alt-Delete the application (The Front End) and restarting it could not connect.

Power failure. The power blew in the whole building, causing a corruption I couldn't fix by compact and repair, so had to rollback a day to the latest save.

Local I have seen it, when I edit code on forms, while the form is running (I.e. in break mode). This has caused me to always close forms before doing my code edits.


I hope that might have at least given you some things to think about.

[patjones]

Hi,

In addition to Smiley's good comments, I would also point out that I used to have problems when having all my users connecting through the same copy of the front end on a network drive. You mentioned that you're using AutoFE, so I'm assuming that each user has their own front end copy, but I point it out here just in case anyone else is looking for solutions to the same problem. Ever since I gave all my users their own front end copies, corruption issues have disappeared.

Pat