Copy a database

J

JF Bouthillier

Hi all,

Does someone know an easy VBA command to copy a database
to the floppy drive?

Thank you.
JF
 
D

Douglas J. Steele

FileCopy "C:\SomeFolder\SomeFile.mdb", "A:\SomeFile.mdb"

You can't use this to copy the current database, though (nor any other file
that's in use). However, that shouldn't be viewed as a limitation of the
method: you should never copy an open database, as it's likely to end up in
an inconsistent state. (Yes, I know there are methods that will allow you to
copy an open file, but just because you can doesn't mean you should...)
 
Top