Can ACCESS97 recognize Oracle relations made up of Composite FK

From: nctsw <leo.wang_at_nctsw.navy.mil>
Date: Tue, 29 Sep 1998 11:33:25 GMT
Message-ID: <1998Sep29.105641.16759@nosc.mil>

Hi,

Help!
My users are using ACCESS97 as an ad-hoc tool for Oracle tables. They can link to Oracle tables with: File | Get External Data | Link tables -> ODBC DataBases.

The Oracle tables and all relations with FK of a single column linked fine. But ACCESS97 is not recognizing Oracle FKs with multiple columns. Is there way around this?

I am using ORacle V7.15 on VAX, ORacle's latest Win95 ODBC driver, and ACCESS97 SR2, on Win95.

Thanks. Received on Tue Sep 29 1998 - 06:33:25 CDT