Question abt remote query! *7282008

  • Thread starter Thread starter J.Alladien
  • Start date Start date
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!
 
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 :)
*
 
Back
Top