Re: How do I setup up an Access table relationship between databases?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Conceptually, that has some problems. What if someone used DB2 and entered
some data without realizing that DB1 has a related table? If you want to
establish and enforce a relationship between DBs, I believe you'll have to
write code and put it in BOTH DBs.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"DALE CHIACCHIO" <DALE CHIACCHIO@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:29B4476D-61E7-4FC9-812D-4A898372D6B7@xxxxxxxxxxxxxxxx
I am trying to setup a relationship with between tables in different
databases? Is this possible?

Thank you


.

Relevant Pages

  • Probleme beim öffnen eines Berichts im Preview
    ... DB1 ruft in DB2 eine Funktion auf um einen Bericht ... Beide DBs linken die gleichen Tabellen. ...
    (microsoft.public.de.access)
  • Oracle Tabelleninhalte kopieren
    ... DB2 ist eine Kopie der DB1 zu einem alten Stand. ... Die Struktur ist somit bei beiden DBs gleich. ... Ziel ist es nun einige aktuelle Tabellen von DB1 ...
    (de.comp.datenbanken.misc)
  • OpenDatabase help please?
    ... tables is split across the 2 DBs, so half of the data is stored in the ... DB1 does not have its database-password set. ... DB2 DOES have a database-password. ...
    (microsoft.public.access.externaldata)
  • Active Directory and Integrated security
    ... as far as Windows Authentication and AD go. ... Users, independant of class, need access to 1 or more DBs, ... so when DB2's project closes, I just remove the DB2 groups ... DB1_xxx groups have AD permissions to the DB1 AD ...
    (microsoft.public.sqlserver.security)
  • Re: DB2 audit
    ... scanner that focuses on DBs. ... > We would like to perform an audit on a DB2 database ... > NGSSQUIRREL for DB2 ... > Do you Yahoo!? ...
    (Pen-Test)