Copy Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JF Bouthillier - 02 May 2005 19:37 GMT

Hi all,

Does someone know of an easy way to have a command button
copying a database to a floppy disk?

Thanks.
JF

Reply to this Message

Jeff Conrad - 02 May 2005 21:09 GMT

> Hi all,
>
> Does someone know of an easy way to have a command button
> copying a database to a floppy disk?

Did you see MVP Doug Steele's response to your previous message
on the same subject???

Here it is again:

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Signature

Jeff Conrad
Access Junkie
Bend, Oregon

Reply to this Message

Paul Overway - 02 May 2005 21:24 GMT

Whether you'd find many databases that would actually fit on a floppy is
another question though!

Signature

Paul Overway
Logico Solutions
http://www.logico-solutions.com

>> Hi all,
>>
[quoted text clipped - 16 lines]
> to
> copy an open file, but just because you can doesn't mean you should...)

Reply to this Message

Ofer - 02 May 2005 21:37 GMT

This command line will copy your MDB even if you currently working with it

res = shell("xcopy c:\MDBNAME.mdb A:\")

> Hi all,
>
[quoted text clipped - 3 lines]
> Thanks.
> JF

Reply to this Message