Hi

Can someone point me in the right direction please.
I want to copy an access database from one disk location to another using
VBA.

The reason for this is that I have an odbc link to a database and I want to
use it to read a different database without having to rebuild the query. I
have found that for me the easiest way to do this is to copy the live
database into a temporary location which msquery can read, then to change
the database just copy the new database over the top. But I want to do this
all from within excel.

So any pointerswould be appreciated.

Many Thanks

Chris