Run update query located in another access database

[gammaman]

Is it possible to run an update query located in another access database?



Something like?

Dim db,db2 as Database

Set db = CurrentDatabase()
Set db2 = "My other database location"

DoCmd.OpenQuery "RUN A QUERY FROM DB2", , acReadOnly

[ranman256]

no, but you could link the external db table, and import the query to your db,
THEN run the query.

[gammaman]

no, but you could link the external db table, and import the query to your db,
THEN run the query.

Ok, thanks. My database currently has 60 queries and is still growing. Is there any point when it could become a problem?

[JoeM]

Ok, thanks. My database currently has 60 queries and is still growing. Is there any point when it could become a problem?

I have seen a lot more than that!

Queries are not like data, they are just code. So queries themselves do not take up much space.

[ItsMe]

no, but you could link the external db table, and import the query to your db,
THEN run the query.

This code here will do the trick.

Dim wrk As Workspace
Dim db As DAO.Database

Set wrk = CreateWorkspace("AccessWorkspace", "admin", "", 2)
Set db = wrk.OpenDatabase("\\Server\Folder\DB_Name.accdb")
db.Execute "qryTest"