How to link two databases

[RobinRBrown]

Good Morning
I have a question that involves using access 2003. I have created a database with just tables in it, so that I can work, fix, create more tables if someone is working with the other database that I want to create. The other database will have the queries, forms and reports. I do not know how to link the two databases. Thanks for your help

[JoeM]

Right click on "Tables" under "Objects" and select "Link Tables".
Browse to your database, double-click it, then select all the Tables from that database that you would link to this one.

[tanvi]

As per my knowledge, we can only link to tables in another Access database. You cannot link to queries, forms, reports, macros, or modules. For this use following steps:
1. Prepare to link tables in an Access database
2. Identify the tables to which you want to link.


Ref: http://office.microsoft.com/en-us/ac...001227658.aspx