link query in 2nd database

[marjo]

Hi,

I want to link (not import) a query into another database. is this possible, or can I just link tables in other databases? Is there maybe a VBA code to do so?

Thanks a lot

marjo

 

[pcs]

you can do either...no VBA required.
you can link tables in another database, (probably the best solution) by selecting Get External Data>Link Tables and selecting the db tables you desire.
or you can create a query with tables from another db, by starting a new query with the QBE grid. right click and select properties...set Source Database to
c:\YourPath\YourDatabase.mdb. you can then use this query in another query that accesses the tables in your db.

hth,
al





[This message has been edited by pcs (edited 11-22-2001).]

 

[marjo]

Thank you very very much, it works!!

)))