MS Access to Oracle table with more than one varchar2(2000) field

From: <nbrown_at_epnet.com>
Date: Sat, 24 Apr 1999 02:19:29 GMT
Message-ID: <7fr9ne$241$1@nnrp1.dejanews.com>

Hi-

I am trying to link via ODBC an Oracle 7.3 table to MS Access and am getting the following error message:

Invalid field definition 'TableName' in definition of index or relationship

I am wondering if this has anything to do with the fact that the Oracle table I am trying to connect to has more than one varchar2(2000) field in it. Does MS Access treat these as memo fields and impose a limit on the number of memo fields allowed in a table, even though it is a link? Does anyone have any experience with this problem? Any ideas on how to get around it? Thanks

nbrown_at_epnet.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 23 1999 - 21:19:29 CDT