Relation tables between diferent database!

[Ricardo Ivan]

How I can make relation tables between
iferent database!?

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


In encrase database!! 300 mb!

 

[Jack MacDonald]

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!

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[Tim Ferguson]

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

 

[Jack MacDonald]

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.

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

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[John Vinson]

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]