Backing up the .mdb automatically

I

Iram

Hello.
Does anyone know how to create a macro that will automatically backup copy
of the .mdb that you are working in at the click of a control button on form?
If not in a macro any other way would be ok too. I would like my customers to
be able to click on a button in the mdb or "even" a shortcut on the desktop
to a batch file that will automatically backup the .mdb to the root of C:\. I
wouldn't mind either way.

Your help is greatly appreciated.

Iram/mcp
 
D

Douglas J. Steele

You cannot backup the currently active database.

Depending on what version of Access you're using, you should be able to use
MichKa's TSI SOON (Shut One, Open New) database add-in at
http://www.trigeminal.com/utility.asp?ItemID=8#8 (I know it only mentions
Access 97 and 2000, but I believe it should work with Access 2002 and 2003
as well)
 
T

tish

About using the Tools > database utilities > backup database function? This
is done while the DB is running, no?

Is there a way to then create a command button as the OP described? I
haven't quite been able to study macros in Access yet, so I'm looking for
help, too!

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
back up data base 4
Access Access Report Works on One Machine but not Another 3
Wise to set up user level security for a multi FE MDB ?? 9
Problem openning DB 1
How do I join a secure .mdb that was created with 2003 with 2007 0
Import Spreadsheet Problem 3
Import Spreadsheet Problem 1

Top