Corruption!!!!!!!!!!!!!!!!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was supposed to deploy my database to production today. I have found that
it is corrupted. F@@@@@@ck!!!

I have sent it to EverythingAccess corruption repair service out of sheer
desparation.

Has anyone used this service? Please let me know if it works. If any one has
a good service please let me know ASAP.

Thanks, Robert
 
Hopefully you'll start keeping backups now. Hard way to learn the lesson,
though.
 
I was supposed to deploy my database to production today. I have found that
it is corrupted. F@@@@@@ck!!!
Click to expand...

Gnnnnnn....

Note for the future:

KEEP BACKUPS. Often.

Sorry this happened and hope the recovery service works!

John W. Vinson [MVP]
 
I helped was able to help someone with a corrupted db recently. Luckily, the
corruption was limited to 5 records in one table. And that table had an
auto-number field as an ID. If by some chance you have the same scenario,
this is what worked for me:
I copied just the data structure of the corrupted table to a new table,
tblRepaired. Then I created an append query that identified the records
before the first corrupted record (ID < corruptedRecordNumber). I ran the
query several more times to get the records after one corrupted record and
before the next corrupted record (ID > firstCorruptedRecord AND ID <
nextCorruptedRecord). Then I simply deleted the corrupted table and renamed
tblRepaired.

After doing this I was able to compact and repair the db and all is well.

In any case, my condolences,
Judy
 
In
RobUCSD said:
I was supposed to deploy my database to production today. I have
found that it is corrupted. F@@@@@@ck!!!

I have sent it to EverythingAccess corruption repair service out of
sheer desparation.

Has anyone used this service? Please let me know if it works. If any
one has a good service please let me know ASAP.
Click to expand...

Peter Miller at PKSolutions (www.pksolutions.com) has an excellent
reputation.
 
Back
Top