query using external data

[Guest]

i have two different databases that need to run seperate as they have
completely different functions. the first is the main database with all
transactions entered on one table, the primary key is [transaction number].

the second is a despatch system which needs to use the transaction table to
do queries on. I need to be able to create a table in the despatch system
with the transaction number in. that table needs to be linked to the
transaction table on the first database using a query. is this possible? i
would even be happy if it imported the data from the transaction table so
long as it did it automatically.

please help.

regards chris

 

[Marshall Barton]

i have two different databases that need to run seperate as they have
completely different functions. the first is the main database with all
transactions entered on one table, the primary key is [transaction number].

the second is a despatch system which needs to use the transaction table to
do queries on. I need to be able to create a table in the despatch system
with the transaction number in. that table needs to be linked to the
transaction table on the first database using a query. is this possible? i
would even be happy if it imported the data from the transaction table so
long as it did it automatically.

You can do that just be setting a query's Source Database
"property".

But, that's not the usual approach to this kind of thing.
Normally, you would Import the table and choose the option
to Link it. Then you can create ordinary queries that refer
to the linked table the same way you would a local table.

 

[[MVP] S.Clark]

Assuming that you mean that you have two .mdb files, and that you want a
table from a.mdb to use in b.mdb....

File / Get External Data / Link Tables...
Navigate to .mdb with the table
Select the table