|
| 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
September 25th, 2008, 07:38 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
relationship between 2 databases
I have one front end application which links to 2 different backend
databases. I wanted to create a relationship between 2 tables which belongs different databases. Is it possible? If yes, how can I create a relationship between different databases? Your help is great appreciated, 
|
|
#2
September 25th, 2008, 09:53 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
relationship between 2 databases
If you are trying to use the Cascading Update/Delete portion of the
relationship, be aware that one database won't "know" what's going on in the other. If you want referential integrity among two separate data sources, you'll need to write the code to enforce that. Regards Jeff Boyce Microsoft Office/Access MVP "inungh" wrote in message ... I have one front end application which links to 2 different backend databases. I wanted to create a relationship between 2 tables which belongs different databases. Is it possible? If yes, how can I create a relationship between different databases? Your help is great appreciated,
|
|
#3
September 25th, 2008, 11:26 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
relationship between 2 databases
On Thu, 25 Sep 2008 11:38:20 -0700 (PDT), inungh wrote:
I wanted to create a relationship between 2 tables which belongs different databases. Is it possible? No. Neither database can prevent someone from opening the *OTHER* database and making a change which would violate the constraint. -- John W. Vinson [MVP]
|
|
#4
September 29th, 2008, 12:08 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
relationship between 2 databases
On Sep 25, 6:26*pm, John W. Vinson
wrote: On Thu, 25 Sep 2008 11:38:20 -0700 (PDT), inungh wrote: I wanted to create a relationship between 2 tables which belongs different databases. Is it possible? No. Neither database can prevent someone from opening the *OTHER* database and making a change which would violate the constraint. -- * * * * * * *John W. Vinson [MVP] Thanks millions,
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
