Copy a database

[JF Bouthillier]

Hi all,

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

Thank you.
JF

 

[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...)