How to use one DB file in many other DB applications ?

[cement]

Hi,



lets suppose we want to use some country names in our many database projects, and we don't want to make the changes to each of those by having a parallel Table in each application, so we want a separate access file with the Countries table in it and then we want to use it in our many other DB projects.

how could it be done ?

hope i explained well what i want to do.

[weekend00]

are you talking about linked tables?

[cement]

actually i am a bit familiar with linked tables and relationships ( in the same database file),
but i want to relate two different tables in two differenct database files (.accdb in access 2010)
and i don't know how to do that.

[weekend00]

I think we can treat a linked table the same way as a normal table, can't we?

[cement]

Thanks,
i was totally forgetting that i can link that separate database file.