Link Queries?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark Smith - 16 Nov 2005 18:26 GMT

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.

Reply to this Message

Amy Blankenship - 16 Nov 2005 19:09 GMT

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

> 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
[quoted text clipped - 4 lines]
> 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.

Reply to this Message

Mark Smith - 16 Nov 2005 19:33 GMT

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.

> If the table exists as linked in Database A, you should be able to just
> import the query from Database B and run it.
[quoted text clipped - 11 lines]
> > 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.

Reply to this Message

Amy Blankenship - 16 Nov 2005 20:00 GMT

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

HTH;

Amy

> The refresh query uses tables that only exist in Database B...to refresh
> the
[quoted text clipped - 22 lines]
>> > from having to go to Database B just to refresh the table. Thanks a
> lot.

Reply to this Message

Jack MacDonald - 17 Nov 2005 02:52 GMT

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
[quoted text clipped - 20 lines]
>> > from having to go to Database B just to refresh the table. Thanks a
>lot.

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Reply to this Message

Chris2 - 17 Nov 2005 07:21 GMT

> 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.

Reply to this Message