relationship between 2 databases

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

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
 
J

John W. Vinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save as word to xml is splitting place holders ex: $abc.xyz$ 0
Excel - Wich Function should I use? 1
Link a text box based on drop down box with four options MS Word 365 0
How do I setup up an Access table relationship between databases? 3
many databases, one project 1
Create a chart from a table in word thats dynamic 0
Document Merge Formatting Issue 0
List all tables, including document structure 0

Top