Linking two database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Now i hava a urgent problem in access query.
I have 2 databases that carry 2 different years records, i would like to
write a query for searching cross database data, how can i do that??
 
Jaye,

You need to have both tables in the same batabase file; if they are
indeed in different fiels, as your wording suggests, then simply link
one into the other (or both in a third mdb). Once you have both tables
tables in a database, then simply make a Union query on them; look up
Union queries in Access help.

HTH,
Nikos
 
Thanks Nikos Yannacopoulos~

But I still not understand how to do. Now I have 2 databases both are
contain a same set of table and same structure. You are suggested that using
Union to solve the my problem, but as I know that Union must be used in same
database. Is that can use in crossing database???
 
Do you have two similar tables in the same database file, or two similar
tables in two different database files?

If in the same file, then just make your union query on them

If the two tables are in two different files, then select one of the two
fiels to work in, open it, go File > Gent External Data > Link Tables to
add the table in the other file as a linked table. Now you have both
tables available in one database file (one belinging to it, and one
linked) and you can make your Union query.
 
Back
Top