backup Access app

[Guest]

I have a stand-alone Access 2002 mdb that uses a
switchboard, multiple custom forms, custom menus, etc.
What I want to do is add a button to one of the forms that
will create a backup of the entire mdb. Is this
possible ? If so, how?

 

[Van T. Dinh]

Generally, it is not recommended to copy the database while it is still
open. However, you can use the MichKa's utility "SOON" to close your proper
database, open another database which can then copy your closed database
file.

See MichKa's article:

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8

 

[John Vinson]

I have a stand-alone Access 2002 mdb that uses a
switchboard, multiple custom forms, custom menus, etc.
What I want to do is add a button to one of the forms that
will create a backup of the entire mdb. Is this
possible ? If so, how?

I would recommend NOT backing up an Access database while it's open;
the backup may well be left in an unpredictable state, possibly
corrupted.

Instead just make a copy of the .MDB file while you're NOT in the
database.

 

[Adam]

I thought I read somewhere that it wasn't possible to make
a backup while the file was open. I tried using a copy
command, and sure enough a copy was made while still open.

Anyway, I agree that file should be closed first before
backing up.

Try the following solution.

Create a text file and put in the following statememt:

Copy file1.mdb file2.mdb

Where file1 & file2 are the names of your files.

Save the file with a bat suffix. Leave this executable in
the directory/folder where your db files are. Create a
shortcut to your desktop.

Everytime you want backup, click the shortcut.

Before you put it into full use, backup your db in a
secure folder/directory until you see that it works
properly.

Adam

 

[Van T. Dinh]

You can copy but the new copy may not be reliable or consistent if other
users update data while you copy the database.