asked on

Restoring an Microsoft Access DB?

Is restoring a MS-Access DB as easy as just placing the backed-up .mdb file in the correct location?

I have a live site that's using MS-Access. Something happened and some data became lost. Our IT Admin got the .mdb backup and is ready to do a restore.

Is that as easy as just replacing the current (corrupted) .mdb file? If so, can the users just start using the site once the backed-up .mdb file is placed in the correct location?

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Yes ... just be SURE ... EVERYONE is out of the corrupted db ... ie no LDB file is present ... or if it is, try to Delete it ... if that does not work, then some one is still in.

mx

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

<Our IT Admin got the .mdb backup and is ready to do a restore.>
How "recent" is the backup?

You may have to double check to be sure that all the records are there...

Scott McDaniel (EE MVE )

Also try to determine what caused the corruption, since it's very likely to happen again. You might want to Compact that backup before putting it into service. You can do this directly in Access, or you can use command line stuff, assuming you have a version of Access available.

Modifier1000

ASKER

Thanks for all responses!