Question abt remote query! *7282008

J

J.Alladien

Dear All

So I have an append QRY "C" in DB"A" and I want to run it from DB"B", is
this possible? If yes can anybody send me an example!

appreciate the help!
 
S

strive4peace

Dim accApp As Access.Application

Set accApp = CreateObject("Access.Application")

with accApp
.OpenCurrentDatabase "c:\path\filename.mdb"
.CurrentDb.Execute "Queryname"
.CloseCurrentDatabase
.Quit
end with

set accApp = nothing


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
 
Top