relationship between 2 databases

  • Thread starter Thread starter inungh
  • Start date Start date
I

inungh

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,
 
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
 
I wanted to create a relationship between 2 tables which belongs
different databases.

Is it possible?
Click to expand...

No.

Neither database can prevent someone from opening the *OTHER* database and
making a change which would violate the constraint.
 
Back
Top