relationship between 2 databases

[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,

 

[Jeff Boyce]

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

 

[John W. Vinson]

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.

 

[inungh]

No.

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

Thanks millions,

 

[kerryanne]

Hi there

Yes link to the table and then create a relationship between the two.

Kerry :O)