MSAcess to Oracle via ODBC - problem with varchar2(2000) field

Using MSACCESS 7.0 and Intersolv DataDirect ODBC driver for Oracle 7, I have tried to link to an Oracle table that includes a not null field that is varchar (2)2000. When I try to link to this table, Access throws an error that references that table field ('Invalid field definition 'Field Name' in definition of index or relationship'). I am wondering if Access has a problem with that field size being set up as not null field (does it interpret it as a memo field and not allow it to be not null?). I have also tried to connect using a Microsoft for Oracle ODBC driver, and have the same results. Also curious is that I can connect to the table in question using MSQuey and the Microsoft for Oracle driver, but not the Intersolv driver. Any ideas or thoughts on this would be greatly appreciated. Thanks...

Nathaniel

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Dec 04 1998 - 10:23:51 CST