Help! How to join two database

[tessie]

Hello,

I have two database that I need to join together. These two database contains peoples names. What we are doing right now is if we don't find a person in one database eg. database "A" we would go into the other database "B" and look there.

How do I combine both database together so that we only search in one????

The help is greatly appreciated!!! If you need anymore information on my side to help me out on this let me know.

 

[FoFa]

Two ways, import the data from the other DB and use it in one, or link the table, and create a UNION query (one on each table) you can base your search off of. I used the UNION query using different different DB's such an access table and an older Fox Pro table as an example with good results.

 

[tessie]

Does my tables have to match in both database in order for me to link?

 

[FoFa]

When you link an MSAccess DB it is pretty much like that table is part of the current DB, except you can't design (change the structure) of it. Looks at Pat's reply and see if there any issues she covered. Let us know if we can be of any other assistance.

 

[tessie]

I would like to just maintain one database and merge both tables together. I'm just not quite sure on how to do this.

In answer to the above question from Pat:
1. Yes, this is a one time conversion.
2. There are some person that exist in both databases but I want to also merge the ones that are in one table but not in the other.
3. Some of the fields in the tables are related.
4. Database A has a primary key and Database B does not.

Thanks...