Relation tables between diferent database!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ricardo Ivan - 30 Dec 2004 12:43 GMT

How I can make relation tables between
iferent database!?

It's possible relation up tables in vinculation tables!!???

In encrase database!! 300 mb!

Reply to this Message

Jack MacDonald - 30 Dec 2004 15:49 GMT

You must LINK to the tables in the other database. From the Menu,
choose File > Get External Data > Link. Once that is done, you can
treat the external table as if it were in your original database.

Sorry, but I don't understand your second question about "vinculation
tables"

>How I can make relation tables between
>iferent database!?
>
>It's possible relation up tables in vinculation tables!!???
>
>In encrase database!! 300 mb!

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Reply to this Message

Tim Ferguson - 30 Dec 2004 17:10 GMT

> You must LINK to the tables in the other database. From the Menu,
> choose File > Get External Data > Link. Once that is done, you can
> treat the external table as if it were in your original database.

Actually, this is not a helpful response to the original question. It is
_not_ possible to create relationships between linked tables.

If you think about it for a moment, the reason is clear. If a a table
inside A.mdb is referenced by foreign key in a table inside B.mdb, then a
user using A.mdb could delete a row that is still referenced, because B.mdb
is not open. Even worse, a user could delete the whole file A.mdb, thus
immediately rendering the other table in B.mdb invalid.

The answer is, I am afraid, that relationships can only be declared and
enforced within the same database.

B Wishes

Tim F

Reply to this Message

Jack MacDonald - 30 Dec 2004 19:48 GMT

I had made the assumption that when the original poster had said
"relation" that he was actually intending to say "join". If he meant
the former, then you are correct. If he meant the latter, I believe
that my response was correct.

>> You must LINK to the tables in the other database. From the Menu,
>> choose File > Get External Data > Link. Once that is done, you can
[quoted text clipped - 15 lines]
>
>Tim F

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Reply to this Message

John Vinson - 30 Dec 2004 19:54 GMT

>How I can make relation tables between
>iferent database!?

No you cannot. You can create Queries using linked tables, but you
CANNOT enforce relational integrity.

>It's possible relation up tables in vinculation tables!!???

I'm not certain that I understand, but if "vinculation" means linked
tables (using File... Get External Data... Link) then no, you cannot.
Relationships can only be set between tables in the same database, and
the relationships must be defined in that database.

>In encrase database!! 300 mb!

Have you used Tools... Database Utilities... Compact and Repair? It is
necessary to do so to recover lost space and make the database more
efficient.

Access2000 and later allow up to 2000 mb so you should be all right at
300.

John W. Vinson[MVP]

Reply to this Message