auto back access database

[sam]

Hi All,

I have an access database. What is the best way to backup the data. I would
like to auto backup the data once everyday. Is there a way to do it?

Thanks in advance

 

[Vince Clortho]

I created a batch file using the dos command "copy" which places a new copy
of the database to my backup location. Use the /Y switch to overwrite. Then I
used the Windows Scheduler to run the batch file nightly.

copy /Y <full path of file to be backed up> <full path of backup location>

 

[NAS]

Here is the one we use:

xcopy \\mcusquanfs11\2nd_maw\2nd_MAW7\WCPAC\COMMON\DATABASES" "G:\Daily
Database Backup" /K/E/D/R

 

[sam]

Thanks for the help NAS, I am new to access. Do I copy and paste your code
somewhere? if yes, where and how do i do this?

Thanks in advance

 

[sam]

Thanks for the help Vince, I am new to access. Where do I insert the copy
command?

Thanks in advance

 

[NAS]

I would have to let Vince asnwer this one for you since I didnt make the
batch file. I'm fairly new to access myself.

 

[Sam]

Hey Vince, can you please help me with auto backing up my access database?

I know you told me to create a batch file using the dos command "copy" which
places a new copy, but I dont know how to do that.. Can you please guide me
through.

Thanks in Advance