[AccessD] Auto Backup

Hi john

There are a few ways this can be achieved

You could call a simple batch file - via VBA
Call Shell("c:\MyWayCoolBatchFile.bat", WIN_NORMAL)

There is also the FileCopy function within access
It has 2 parameters
1= The file to be copied path 
2 = The new destination path
EG FileCopy "C:\someCoolFile.mdb","x:\MainServer\someCoolFile.mdb"

Then you can roll your own - Testing for file existence, copying to a path held
in some options table somewhere, appending datetimestamps to the file name etc
etc

Hope this helps
 
Darren

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Serrano, John K
Sent: Saturday, 22 November 2008 1:29 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Auto Backup

Has anyone ever done an auto backup within access 2003?

 

I have a database that I would like to auto backup on close.

 

I know there is an auto backup on the file menu; however has anyone done
this in code before?

 

 

John Serrano

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com