Link Queries?

[Mark Smith]

I'm just an Access newbie, so I have a really dumb question. I have
Database A, which contains a link to a table in Database B. This table has
to be manually refreshed sporadically, using a query in database B. Since
the end-user does almost all of their work in Database A...is it possible to
link the refresh query from Database B to Database A? This will save them
from having to go to Database B just to refresh the table. Thanks a lot.

 

[Amy Blankenship]

If the table exists as linked in Database A, you should be able to just
import the query from Database B and run it.

HTH;

Amy

 

[Mark Smith]

The refresh query uses tables that only exist in Database B...to refresh the
table that is linked in Database A. I was just hoping there was a way to
have the query linked in Database A which will start the refresh process in
Database B. Thanks.

 

[Amy Blankenship]

You might be able to use a pass-through query, but I haven't used these
before.

HTH;

Amy

 

[Jack MacDonald]

In Database A, create links to the tables in Database B. Copy your
query into Database B. It should execute just fine there.

The refresh query uses tables that only exist in Database B...to refresh the
table that is linked in Database A. I was just hoping there was a way to
have the query linked in Database A which will start the refresh process in
Database B. Thanks.

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[Chris2]

I'm just an Access newbie, so I have a really dumb question. I have
Database A, which contains a link to a table in Database B. This table has
to be manually refreshed sporadically, using a query in database B. Since
the end-user does almost all of their work in Database A...is it possible to
link the refresh query from Database B to Database A? This will save them
from having to go to Database B just to refresh the table. Thanks a lot.

Mark Smith,

You may operate on tables in other MS Access databases.

Place a copy of Northwind.mdb in c:\

Create a new blank MS Access database, and create a query in it.

In SQL View, paste the following:

SELECT *
FROM [c:\Northwind.mdb].Categories;

This lists the contents of the Categories table, even though it
occupies a differet .mdb file.


Sincerely,

Chris O.