470,638 Members | 1,633 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,638 developers. It's quick & easy.

Records in Access corrupting and Compact/Repair function not able to resolve this.

Windows XP Pro OEM user OS,
Windows Sever 2000 server OS.

Not-so-recently I inherited 3 Access DB's from another company merging with our own. Our own system works off of SQL server, but mainting these databases is critical to keeping the business running. 1 database in particular has been causing problems. Along the course we have had a few problems with random records corrupting (new and old) and Values within fields dissapearing, which are formatted text-boxes (checked With VB code as opposed to locking down the fields to a certain type, which i believe is part of the problem).

In the past: records would courrpt, users would recieve the relevant Run-time error and the database would be compact/repaired and then everything would operate normally for a spell. However after a time, it got to the point where records would corrupt and a repair would not work. Halfway through the Compact/Repair process Access stalls and gives a message that it has to restart. A copy of the database it made (incomplete) and placed in the same directory named DB* (where * is an incrimental number based on how many copies of the DB exist inthe current directory). Again this wasn't a big problem, as i have scheduled (along with daily backups) an hourly back of each of the 3 databases, which normally is faster than repairing the database and means at most an hour of work is lost.

The most recent issue however is that a very old record that hadn't been accessed in months corrupted, this went un-noticed until recently and now it's too late to restore from a backup. the compact/repair still does not work - and other repair facilities (the jet engine repair util for example) crashes while trying to repair it also. I have tried going into the back end, but as soon as i try to remove the corrupted records, it becomes impossible to save the changes due to the "unrecognised database format" error message.

These systems will be moving onto our own, more powerful database engine and workflow management system soon, but this corrupted record will not allow exporting of records, as this also crashed accesss. So until this issue is resolved we are unable to push forward with the migration and i have been unable to find a solution to the problem.

If anyone has any ideas, it's all appreciated - i have been working on this for weeks as it stands - im at the point of trying anything!
Feb 20 '08 #1
3 1984
Scott Price
1,384 Expert 1GB
Allen Browne's website has two very helpful pages: Recovering from Corruption and Preventing Corruption that should help you understand the underlying causes and the possible fixes to corruption.

Good luck!

Feb 20 '08 #2
Scott Price
1,384 Expert 1GB
Another very helpful page: http://www.everythingaccess.com/tuto...n-Repair-Guide .

Feb 20 '08 #3
Thanks for the info - I'll check these out now.
Feb 20 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Mohammed AlQuraishi | last post: by
12 posts views Thread by John Baker | last post: by
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.