Ah Ha! I created a new DSN with PostgreSQL+(Beta) and it correctly interpreted the UR Notes as
a memo field. Went back with another new DSN using PostgreSQL+Unicode(Beta) and it would
not take it as a memo field. Presently I don't think the Unicode is critical for my app but I think its
something that should be corrected if possible.
Thanx VERY much for your help,
Ben Scherrey
11/27/2002 5:10:21 PM, "Dave Page" <dpage@vale-housing.co.uk> wrote:
>I just tried linking this table with:
>
>psqlODBC 07.02.0004
>PostgreSQL 7.3rc1/Cygwin
>Access XP
>
>And it works perfectly using a DSN with all default settings:
>
>ID Number
>Date Opened Date/Time
>Name Text
>Account# Number
>Date of Birth Text
>Attending MD Text
>Health Plan Category Text
>County Text
>Case Status Text
>UR Notes Memo
>
>Regards, Dave.