Copy backed up Access database to production version 2

[mikepf]

Is it safe to restore an entire backed up version of an Access database to the production version? Or is the best way to copy in only those objects from the backed up version to production?

If I delete the production version first, then I would have to setup short cuts again for all users. Please advise. Thanks!

 

[JerryKlmns]

Backed up database name LALA.mdb
Production database name OneWonderfulName.mdb

Delete production database, copy backed up to the same folder and rename the copied backed up to the production name. No relinking required.

If backed up is not of the same version of production then there is a problem

 

[Hap007]

Hi,

Backing up an Access database can be a little tricky if it is shared by multiple users.

Most backup software will not copy the file if one or more users have the database open.

You can just make a copy of the database, but again, this can be corrupt if any users have the database open and are writing to the database.

What I do,
1) Make sure all users are out of the database.
2) Rename the database, this makes sure no one is in the database
3) Copy the re-named file
4) Now re-name the original DB back to the original name.

I now have have a good backup.

Any time you want to restore,
1) Delete original DB (Note: All users must again be out of DB)
2) Copy your 'Renamed' backup copy to the correct folder
3) Rename backup DB to the original file DB name.

This assures that all users are out of the DB during the copy, and during the restore.

Works for me every time,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121