Re: linking tables in separate databases

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 03/26/04


Date: Thu, 25 Mar 2004 17:20:48 -0700

On Thu, 25 Mar 2004 12:27:24 -0800, "Lindsey"
<anonymous@discussions.microsoft.com> wrote:

>Is it possible to join tables from separate databases
>together in a relationship, i.e, to connect by a primary
>key ID? If yes, how??

No; you can create a Query linking tables which reside in separate
databases, but you cannot create a relationship (since neither
database has any way of enforcing that relationship).

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public



Relevant Pages

  • Re: New exploit?
    ... something that allowed manipulation of the physical file system (else, ... copied those databases into your website's folders ... : databases which reside above website's roots (eg: website root is at ...
    (microsoft.public.inetserver.iis.security)
  • Re: compact on close when running on a server?
    ... I've always written vb applications that use access databases that have ... database will reside on a server ... I wouldn't think I could leave the Compact on close option checked? ... Has JETCOMP been updated to work with Access 2003 databases? ...
    (comp.lang.basic.visual.database)
  • Re: Database Restore
    ... > I have two 9.2.0.4 databases on the same Solaris machine. ... They reside ... > Different SIDS and different datafile locations. ...
    (comp.databases.oracle.server)
  • Moving Database from Server to Server
    ... I need to move a couple of databases from one server to ... another server while preserving the identity columns ... in the tables that reside in the database. ...
    (microsoft.public.sqlserver.server)