Backing up .mdb

[Terri]

What is the best method to use to copy the .mdb file to a
cd from a command button on a form? I had been using the
Shell function to run the very ancient xcopy.exe command

retVal = Shell("c:\windows\system32\xcopy.exe /y
c:\data\file.mdb d:\")

But I'm sure there must be a better way :-0

Thanks - Terri

 

[John Vinson]

But I'm sure there must be a better way :-0

Yes. CLOSE THE DATABASE!! and write a .bat file to copy it, and
execute the bat file from a desktop icon. A copy of an open database
is at great risk of being corrupt, since it's quite possible that
(especially in a multiuser system) somebody is doing something to
update data; the copy may well be caught in an incomplete state.