Printable View
Hi
I have a program that use mdb file to store data.
What I will do with this is to backup the file
I know how to do that, but the question is
how to make backup of the file so I can
go back and restore the file from 10 Days ago.
I mean how to number the file we say
like this phone.mdb
phone.mdb1
and so on
Lenny
You can add date/time stamp to file name. Try something like this:
Code:FileCopy "c:\source_folder\mydata.mdb", "c:\backup_folder\mydata" & Format(Now, "mmddyyy_hhnnss") & ".mdb"
Thanks it works just fine
How can I get the file back from the backup dir?????
Same way... only in reverse... just copy the backup over the original.
-tg
Hi
Okej it works just with one file
If I have several files with different date and time
how to get one of them back.
file.mdb20130509_18:48
file.mdb20130509_19:48
file.mdb20130509_20:18
file.mdb20130509_20:48
Maybe you could put the files in a FileListBox.
You could see what files are available and select the desired one from the list.
If I were you I'd use Rhino's suggestion for the file and append the Date and Time to the Filename rather than Filetype. That will make it (slightly) easier to filter if you're going to use a FileListBox.
In addition to RhinoBull's and Doogle's recommendations, you also shouldn't use a colon (":") anywhere in the filename because doing so creates or accesses the Alternate Data Streams (ADS). See Streams for more info.Quote:
Originally Posted by Bonzo2008
HiQuote:
Originally Posted by Bonnie West
I solved it
REF: "I solved it"
If so, please make this thread as RESOLVED, under 'thread tools'.