Re: Can't get more than 255 chars out of memo field in Acc

> -----Original Message-----
> From: Benjamin Scherrey [mailto:scherrey(at)proteus-tech(dot)com]
> Sent: 27 November 2002 20:24
> To: Tom Lane; Jeff Eckermann
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Can't get more than 255 chars out of memo
> field in Acc
>
> I can't seem to figure
> out what settings are necessary to get Access to recognize
> this as a memo field.
>
> create table "Table-MCMProgram 2000" (
> "ID" serial unique not null ,
> "Date Opened" date null ,
> "Name" varchar ( 50 ) not null ,
> "Account#" integer not null ,
> "Date of Birth" varchar ( 50 ) null ,
> "Attending MD" varchar ( 50 ) null ,
> "Health Plan Category" varchar ( 50 ) not null ,
> "County" varchar ( 50 ) null ,
> "Case Status" varchar ( 50 ) not null ,
> "UR Notes" text null )
>
> Access treats all the varchar and text fields as text
> in my ODBC link. I just need "UR
> Notes" to act like a good old memo field once again so I can
> get more than 255 chars in it.

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.