Restoring an Microsoft Access DB?

Modifier1000
Modifier1000 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
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
Database Architect / Application Developer
Top Expert 2007
Commented:
"If so, can the users just start using the site once the backed-up .mdb file is placed in the correct location?"

Yes ...
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
<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 )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
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.

Author

Commented:
Thanks for all responses!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial