Open Database, run a query, close the database

[papasmurfuo9]

Hi

i have a database that runs updates from within itself.

what i need is, this database to then open a another database
run a update query, then close it

thanks in advance

 

[pr2-eugin]

Can you link the tables in that DB to this? If so then you do not have to worry about opening and closing, you can simply run an update Query from the normal DB.

 

[papasmurfuo9]

thanks for the reply

there is too many tables etc

if possible i would prefer just to open and run the query

thanks

 

[namliam]

Is the update only in the target database or does it require data from your current db as well?

 

[papasmurfuo9]

sorted with

Dim ObjAccess As New Access.Application

With ObjAccess
.OpenCurrentDatabase ("filepath")
.Visible = True
.DoCmd.OpenQuery "Qry_"
.Quit
End With