how to create automatic backup

[khan]

can any one help me how to create an automatic backup of ms access
database. Actually I want it to be done either by just clicking on a
button or automatally make a backup at 6pm every day. plz help

[pietlinden]

there's code for a Scheduler on AccessWeb.
http://www.mvps.org/access/modules/mdl0045.htm

[Tom van Stiphout]

On 22 Nov 2005 10:53:09 -0800, "khan" <ah******@gmail.com> wrote:

Create a batch file (mycopy.bat):
copy c:\mydir\myfile.mdb d:\mybackupdir
Place a shortcut to it on your desktop.

-Tom.

can any one help me how to create an automatic backup of ms access
database. Actually I want it to be done either by just clicking on a
button or automatally make a backup at 6pm every day. plz help

[Ed Robichaud]

There are 3rd party tools ("Total Access Agent" by FMS comes to mind as one)
that will do want you want. Keep in mind that you can't backup (or compact
or copy, etc.) any database that is open, so no coded cmdButton on your form
will do a backup of the database that contains it.
This is even harder in multi-user environments as you'll need all users to
stop accessing the back-end file.
-Ed
"khan" <ah******@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

can any one help me how to create an automatic backup of ms access
database. Actually I want it to be done either by just clicking on a
button or automatally make a backup at 6pm every day. plz help

[khan]

you mean copy the data base on 2 places tom. can you lz explain

[Tom van Stiphout]

On 22 Nov 2005 23:42:43 -0800, "khan" <ah******@gmail.com> wrote:

?
No I mean copy it from some folder (call it c:\mydir) to some other
folder (d:\mybackupdir).
Open a command window, and enter:
copy /?
for more instructions.

-Tom.

you mean copy the data base on 2 places tom. can you lz explain

[altacct]

You definitely can back up or copy an mdb file thta is open. I've done
it brazillions of times over the last ten years and not had a single
issue with it.

Jeremy

[Ed Robichaud]

You can NOT reliably copy/backup/compact an open MDB, particularly in a
multi-user environment. If in doubt, check the MS Knowledge Base on this
topic. Consider yourself extremely lucky for you past experience.
-Ed

<al*****@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

You definitely can back up or copy an mdb file thta is open. I've done
it brazillions of times over the last ten years and not had a single
issue with it.

Jeremy

[Dean]

I created a db that will compact all my other db's and copy them into a
different folder with dbname_BACKUP_DDMMYY.mdb

[Dean]

Dean wrote:

I created a db that will compact all my other db's and copy them into a
different folder with dbname_BACKUP_DDMMYY.mdb

Also, I can use Windows schedule to open the db at midnight perform
it's task, then close.