Linking Queries, like linking tables

[baldeagle]

Is it possible to link the results of a query in Database A to database B?

Other choice is to delete & Append a table with the query results... which is not ideal.

I guess I should mention the whats / whys... I've got a table in Database A that contains lots of data. Database B is interested in a little bit of that data. Database A is where the data is updated. What is the best way to communicate the updated to database B?

-Andy

 

[The_Doc_Man]

It is possible to import data from a query to a temp table and then do a comparison query for updates.

It would also be possible to write VBA code that explicitly opened the second DB and opened a recordset of that query. You could then write VBA code to compare results.

I don't know that I've ever tried to actually LINK to a query as though it were a table. I think it might be a case of Access "knowing too much" to treat it as a table. But heck, try it on a copy of your DB. Make the copy then try to link to the query from the table pane of your DB window. The worst that will happen is that you have to trash the copy.

This still wouldn't do the comparison but it would certainly make it possible to write a query that "thinks" it is working locally. That would help some.

 

[Sergeant]

Out of curiosity, I just tried linking to a query, and it didn't work.
You might just make db "A" table a linked table in db "B", and then you could build the update query in db "B".
I don't know what kind of load this would put on a network (would all the records traverse the network, or just the ones the query returns?).