Microsoft Access

[lisss001]

Is is possible to create 2 microsoft access databases and make a relationship between the data even if I am using 2 different database files ?

 

[Remou]

Yes, but there are limitations.

Defining relationships between tables in a Microsoft Access database

http://support.microsoft.com/kb/304466

 

[GingerR]

Why don't you tell us more of what you are trying to do and maybe we can help you.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[lameid]

Reading through the link Remou posted, it looks like the limitation on relationships is that if you want to set referential integrity between tables, they must be in the same file and the relationship must be defined in the datafile (backend or where the tables are not linked). Also since referential integretity is needed for cascade updates and deletes, it also requires the tables to be in the same file.

This matches my experience.

It is most definitely possible to link both tables into a third file and make a query joining the data together. you could even link one table into a database where antoher table is (probably not a good idea, but possible).