Relation tables between diferent database!

  • Thread starter Thread starter Ricardo Ivan
  • Start date Start date
R

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!
 
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!
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
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.
Click to expand...

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
 
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
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
How I can make relation tables between
iferent database!?
Click to expand...

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!!???
Click to expand...

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!
Click to expand...

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]
 
Back
Top