Is there a way to edit linked tables in two seperate Access databases

[NewProgrammer1234]

I had to break a part a large DB (1 gigabite DB) into two Databases and I am running the same Access VB functions to update the same master tables because each db has a copy in two separate databases. Can I create a link to the master tables from the second database to the first one so that when I run the code to update the tables in the second DB it will edit/update the original tables in the first database and the the other way around(update the copy of the tables in the second db when updates are run on the first db)? In other words, I have two databases that have tables that need to be completely identical so that when 1 set of tables is updated, the second copy will also save the new changes etc. Any answers?? I appreciate any help I can get. Thanks.

 

[tomschafer]

Link the Tables from one DB into the other. Then use Relationships to enforce Referential Integrity.

 

[NewProgrammer1234]

Thanks so much for your time. This is very helpful to me, but I have another couple silly questions. Do I need to enforce referential Integrity in both databses or just one? and how do I enforce referential integrity after I have linked the tables? Thanks again for your time.

 

[tomschafer]

Can you give me an example...Are the both tables in both DB's now?