auto back access database

  • Thread starter Thread starter sam
  • Start date Start date
S

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
 
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>
 
Here is the one we use:

xcopy \\mcusquanfs11\2nd_maw\2nd_MAW7\WCPAC\COMMON\DATABASES" "G:\Daily
Database Backup" /K/E/D/R
 
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
 
Thanks for the help Vince, I am new to access. Where do I insert the copy
command?

Thanks in advance
 
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.
 
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
 
Back
Top