If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relation tables between diferent database!
How I can make relation tables between
iferent database!? It's possible relation up tables in vinculation tables!!??? In encrase database!! 300 mb! |
#2
|
|||
|
|||
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" On Thu, 30 Dec 2004 04:43:35 -0800, "Ricardo Ivan" wrote: How I can make relation tables between iferent database!? It's possible relation up tables in vinculation tables!!??? In encrase database!! 300 mb! ********************** remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security |
#3
|
|||
|
|||
Jack MacDonald wrote in
: 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 |
#4
|
|||
|
|||
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. On Thu, 30 Dec 2004 09:10:19 -0800, Tim Ferguson wrote: Jack MacDonald wrote in : 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 ********************** remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security |
#5
|
|||
|
|||
On Thu, 30 Dec 2004 04:43:35 -0800, "Ricardo Ivan"
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Create secıred database via code ADOX? | Özden Irmak | General Discussion | 15 | September 16th, 2004 03:26 AM |
Link Tables in Database | Ravi Sandhu | New Users | 2 | July 30th, 2004 11:00 AM |
Mutliple Tables lookup? | Westley | Database Design | 4 | June 15th, 2004 01:07 AM |
Separate database for tables? | Holly Clifton | Database Design | 3 | May 18th, 2004 06:20 PM |