Relationships between Multiple Databases

[marblearchibald]

Is there some way of creating relationships accross multiple database files. I'm trying to make a furniture catalogue. There are about 5 or 6 different catagories and I would like to have them in separate files rather than one big file. I've also got Contacts, Staff, and projects in separate files which I would like to tap into to create reports and query's. So far I've only had to work with one file where all the tables and relationships are self contained. If possible maybe someone could recommend a good tutorial to accomplish what I'm trying to do. Any suggestions would be greatly appreciated.

[TonyES]

Follow the below steps:
1. Open MS Access and create a new database.
2. From the file menu, choose File and then Get External Data and then Link Tables.
3.From "Link" window that comes up, choose ODBC Databases.
4. From the "Select Data Source" Window, choose the DSN name you've setup for your online mySQL database.
5. From the "Link Tables" window, select the table you want to attach and click the OK button.
6. ODBC could prompt you for the primary key column in that table, if it can't find it. Specify one and that's it! The online mySQL table is now attached to your local access database:
7. You may open the table, update, insert or delete records. To attach all database tables, follow the above steps for each table in your database.

You can do the above proceedure using another Access mdb file and now the linked table shows up in the relationships window. As promised in step '7.' You can add, delete, and edit any data in this table as if it were part of the same database.

[marblearchibald]

Thanks a lot for helping me out.