torontostar
Programmer
How should we deal with an .mdb file which has been split into a backend database and will not allow compiler to create an .mde file because it has been corrupted?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Corrupted access file
- Thread starter torontostar
- Start date
- Status
JerryKlmns
IS-IT--Management
torontostar,
Back up your corrupted .mdb file. Then try to Compact and Repair. For Compact and Repair on the menu bar click Tools->Database Utilities->Compact and Repair Database... or use this link to get a utility from microsoft.
If no luck then create a new empty database and Import data from the corrupted, table by table or copy paste if possible. Or export all tables as txt files and then import those txt to a new empty database.If still no luck, use your last back up copy of the before corruption BE database. If still no luck..........
Has happened, still happens and will keep happening to a lot of us.
Back up your corrupted .mdb file. Then try to Compact and Repair. For Compact and Repair on the menu bar click Tools->Database Utilities->Compact and Repair Database... or use this link to get a utility from microsoft.
If no luck then create a new empty database and Import data from the corrupted, table by table or copy paste if possible. Or export all tables as txt files and then import those txt to a new empty database.If still no luck, use your last back up copy of the before corruption BE database. If still no luck..........
Has happened, still happens and will keep happening to a lot of us.
... and finally move forward to MSDE for your back end!
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts
- Thread starter
- #4
torontostar
Programmer
Thanks JerryKlmns & johnwm. I will finally move to MSDE soon.
- Status
Similar threads
