Access 2003 macro nubie here.

I have to copy two files from a network location. Both are Access Databases
that need to be stored locally,
then run one of them.

It is currently done via a DOS batch file called by a macro, but I feel this
is a bit clumbsy.(the fewer files the better)
I would like to be able to do this directly within the macro.

So in a nutshell :
1. Copy \\networkpath\mydatabasefile1.mdb and paste to c:\pcdata
2. Copy \\networkpath\mydatabasefile2.mdb and paste to c:\pcdata
3. Run c:\pcdata\mydatabasefile1.mdb

Thanks in advance for your assistance.

find solutions of problems and solution regarding CISCO, CCNA, CCNP, MCSE,
LINUX, WIRELESS, SECURITY, NETWORK, IT NEWS

http://www.theitstuff.co.cc/

http://www.theitstuff.co.cc/understa...isement-types/

http://www.theitstuff.co.cc/explore-...hical-hacking/

http://www.theitstuff.co.cc/what-net...gement-covers/

http://www.theitstuff.co.cc/simple-n...ment-protocol/

http://www.theitstuff.co.cc/importan...e-server-room/

http://www.theitstuff.co.cc/router-as-a-dhcp-server/

http://www.theitstuff.co.cc/assembli...ideo-tutorial/

http://www.theitstuff.co.cc/ccna-and...-protocol-vtp/

http://www.theitstuff.co.cc/nat-conf...-cisco-router/

http://www.theitstuff.co.cc/how-to-m...deo-tutorials/

http://www.theitstuff.co.cc/types-of-network-attacks/

http://www.theitstuff.co.cc/advantag...r-other-media/

http://www.theitstuff.co.cc/learn-tc...imation-video/

http://www.theitstuff.co.cc/firewall-techniques/

Presto,

No, you can't do file amnipulations with macros. You will need to use a VBA
procedure. The syntax would be:
FileCopy "\\networkpath\mydatabasefile1.mdb" "C:\pcdata\mydatabasefile1.mdb"
Application.FollowHyperlink "C:\pcdata\mydatabasefile1.mdb"

--

Steve Schapel, Microsoft Access MVP


"Presto" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Access 2003 macro nubie here.
>
> I have to copy two files from a network location. Both are Access
> Databases that need to be stored locally,
> then run one of them.
>
> It is currently done via a DOS batch file called by a macro, but I feel
> this is a bit clumbsy.(the fewer files the better)
> I would like to be able to do this directly within the macro.
>
> So in a nutshell :
> 1. Copy \\networkpath\mydatabasefile1.mdb and paste to c:\pcdata
> 2. Copy \\networkpath\mydatabasefile2.mdb and paste to c:\pcdata
> 3. Run c:\pcdata\mydatabasefile1.mdb
>
> Thanks in advance for your assistance.
>

"Presto" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Access 2003 macro nubie here.
>
> I have to copy two files from a network location. Both are Access
> Databases that need to be stored locally,
> then run one of them.
>
> It is currently done via a DOS batch file called by a macro, but I feel
> this is a bit clumbsy.(the fewer files the better)
> I would like to be able to do this directly within the macro.
>
> So in a nutshell :
> 1. Copy \\networkpath\mydatabasefile1.mdb and paste to c:\pcdata
> 2. Copy \\networkpath\mydatabasefile2.mdb and paste to c:\pcdata
> 3. Run c:\pcdata\mydatabasefile1.mdb
>

Are you willing to try/use code in place of a macro?

The vba code to do the above is:


FileCopy "\\networkpath\mydatabasefile1.mdb",
"c:\pcdata\mydatabasefile1.mdb"
FileCopy "\\networkpath\mydatabasefile2.mdb",
"c:\pcdata\mydatabasefile2.mdb"
Application.FollowHyperlink "c:\pcdata\mydatabasefile1.mdb"



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)