[AccessD] Add Date/Time Stamp to xcopy target

Rocky Smolin rockysmolin at bchacc.com
Thu Apr 14 17:48:19 CDT 2011


Thanks.  Will forward.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, April 14, 2011 2:43 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Add Date/Time Stamp to xcopy target

Rocky,

I am sure that there are many ways to do this.  Here is the technique that I
have been using for a couple years with no problems.

Brad

;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~
; This script uses a free Open Source tool called AutoHotKey
www.autohotkey.com ; ; This script copies a file to a new file that has a
date-time stamp in the file name ; ; Here is an example file name that was
created with this script ; ; C:\MyFile_Date_2011-04-14_Time_16-27-01.txt
;
;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~


FormatTime, Date_String,,  yyyy-MM-dd    ;;; Format a string called
Date_String

FormatTime, Time_String,,  HH-mm-ss      ;;; Format a string called
Time_String

Date_Time_String = Date_%Date_String%_Time_%Time_String%   ;;; Build a
string called Date_Time_String

Filecopy, C:\MyFile.txt, C:\MyFile_%Date_Time_String%.txt  ;;; Copy the file
to a new file with Date Time in Name


;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~  END
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~






-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, April 14, 2011 3:05 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Add Date/Time Stamp to xcopy target

Dear List:
 
Client wants to do regular backup to his EHD using Windows Scheduler.
He's
almost there but has a question:
 
The following in a batch file seems to work for backing up DocketWorks: 

 

xcopy "W:\DWData.mdb" "C:\ProgramData\DocketWorks"

 

Do you know if there is some way to append a date time stamp to it so it
does not always overwrite the previous backup? 

Anyone know?

 

TIA

 

Rocky

 

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

--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.


-- 
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