Backup

[sir_dan_mitchell]

I need a way that can backup my database straight to the floppy drive. Is there a button that i can create that will automatically do file - save to A: drive or something?

thanks

 

[DJN]

You could use FileCopy.

e.g.

Private Sub cmdFileCopy_Click()
Dim SourceFile, DestinationFile
SourceFile = "FullPathname" ' Define source file name.
DestinationFile = "A:\FileName.mdb" ' Define target file name.
FileCopy SourceFile, DestinationFile ' Copy source to target.
End Sub


Bear in mind though, that you cannot copy an open database.

David

 

[sir_dan_mitchell]

Im sorry I dont quite understand wot u mean. the file is called Vidz.mdb and its in C:\Windows\Desktop. please help

Dan

 

[Geoff Codd]

what i do is keep a blank copy of my database on a floppy. and back up the tables using the transfer text command which you can find in macros or vba, and back them up as csv files