Trying to Automate Database Backup

[npersaud]

I have an access database that I want to set up so that it will automatically make a backup copy of itself every few days (the filename would remain the same except with the date appended to it). I haven't the foggiest idea how to make Access perform this, however. My first two thoughts were to write a VBA script or write a C++ script and have the Access program run it. I still don't know how to make it happen, though!

FYI, this database isn't on a server or anything, really.

[hazard_abio]

I have an access database that I want to set up so that it will automatically make a backup copy of itself every few days (the filename would remain the same except with the date appended to it). I haven't the foggiest idea how to make Access perform this, however. My first two thoughts were to write a VBA script or write a C++ script and have the Access program run it. I still don't know how to make it happen, though!

FYI, this database isn't on a server or anything, really.

Scheduled task plus a Batch File should do it.

Here is a sample of a batch file that I use every now and then.

@ECHO OFF
:: Year
SET D1=%date:~-4,10%
:: Day
SET D2=%date:~7,-5%
:: Month
SET D3=%date:~4,-8%
SET PATHTODB=c:\DB
SET DBFILE=MyDatabase
SET DBEXT=.mdb
SET PATHTOBACKUP=c:\backup

:: Please note if the path to the backup exists within a network path this will not work
:: you will need to map the network drive first.
COPY "%PATHTODB%\%DBFILE%%DBEXT%" "%PATHTOBACKUP%\%DBFILE%--%D3%-%D2%-%D1%%DBEXT%" /Y

[secowu]

@ECHO OFF
:: Year
SET D1=%date:~-4,10%
:: Day
SET D2=%date:~7,-5%
:: Month
SET D3=%date:~4,-8%
SET PATHTODB=c:\DB
SET DBFILE=MyDatabase
SET DBEXT=.mdb
SET PATHTOBACKUP=c:\backup

:: Please note if the path to the backup exists within a network path this will not work
:: you will need to map the network drive first.
COPY "%PATHTODB%\%DBFILE%%DBEXT%" "%PATHTOBACKUP%\%DBFILE%--%D3%-%D2%-%D1%%DBEXT%" /Y

good,it works fine