linking databases 1

[germain2]

I have two separate databases. Can I merge one into the other by copying the tables and forms to one database? If so, how do I link the tables so that I can run one query that pulls data from both databases/ Thanks for your help.

 

[alvechurchdata]

You can right-click in the Tables area of the Database Window and select Import to copy all the tables from on database to another. Same with Forms, Modules or any other component.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[germain2]

Thanks Geoff. I tried doing that and it worked but I get an error message when I try to run a query from both databases. Is there further linking of the tables within relationships or something else? Thanks members.