Had my first database corruption today which produced the following error when entering the database from the front end.
Expand|Select|Wrap|Line Numbers
- Unrecognized database format 'k:etc... path'
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.