Linking to a query?

[andrefrancis]

Can I use a query in Database A as a look-up table in Database B.

When I try File / Get External Data / Link Tables (in Database B), it only gives me a choice of Tables from Database A. Do I need to generate beforehand a physical Table using a MakeTable Query?

Any help or advice would be appreciated.

 

[KenHigg]

I would simply link to the source table and copy the query over and then use it. Would this work?

 

[FoFa]

You must be trying to use an Access (or other non-running DB) query as the source right?
Here is the issue, to use a query from an external source, that DB has to be "running". When you connect to an external Access DB (or Xbase, or paradox as an example) the DB engine is not "running". Access uses the DB file basically as a flat file (think text). Hence queries can not be accessed as linked because there is nothing "running" on the other end to feed the data. Things like Oracle, Sql Server, etc. have a DB engine running and can supply the data (view) so there is the difference. You could however link the underlying tables, and recreate the query on the system that needs it, then use that instead.

 

[andrefrancis]

Thanks KenHigg and FoFa.

Yes ... I understand about the 'running' database ... I will need to link the underlying tables, copy the query and ... work from there.