[AccessD] Auto Backup

Serrano, John K John.Serrano at dayzim.com
Mon Nov 24 10:32:39 CST 2008


Darren,

Thanks I will try this, thanks for responding...


John Serrano
Day & Zimmermann NPS
(757) 233 - 7481 Office
(757) 651 - 4320 Cellular
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren D
Sent: Sunday, November 23, 2008 6:10 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

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




More information about the AccessD mailing list