Making a backup copy, with out using a DOS macro file.

[MatthewDavis]

How do you make a complete backup copy of your backend database? Can you call a windows function, that can copy the backend mdb file and rename the copy with a date? Is a DOS macro the only way to do that?

 

[bobjames]

just use the Shell command to issue your dos copy statement.

 

[Atomic Shrimp]

Can't you just use the Filecopy statement?

Mike

 

[MatthewDavis]

Thanks for the ideas. The filecopy function is what I was looking for. The catch to filecopy though, is you cannot copy a file that is open, it errors. But, on the Microsoft knowledge database is a function, CopyFile. This will let you copy a open file.