Copy a database

  • Thread starter Thread starter JF Bouthillier
  • Start date Start date
J

JF Bouthillier

Hi all,

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

Thank you.
JF
 
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...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Database 3
Record-Locking remains open after closing 0
MS Access and MS Project 1
Discover folder path 1
DB Max Size 2
Issue copying MS database from active application 3
Access database exported to text file 2
Error message prevents form creation 2

Back
Top