SQL query

[valchyshen]

Hi All,

What kind of VBA code will resolve the following? I have two databases. I need to write an SQL query (to be run from db1) that handles the tables from another databases (db2). Notice, that db1 does not contain reference links to the tables at db2.

Thank you very much!

Alexander

 

[dragofly]

You may want to look up the opendatabase method of the workspace object. There info on it and an example in the help files.

Thus you would create a database object and a workspace object and set the database object equal to the workspace object.opendatabase(insertfilenamehere) then maniplulate it using the usual dao objects like recordset and such.

 

[valchyshen]

thank you for this!

 

[dragofly]

No problem