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

> -----Original Message-----
> From: Benjamin Scherrey [mailto:scherrey@proteus-tech.com]
> Sent: 27 November 2002 20:24
> To: Tom Lane; Jeff Eckermann
> Cc: pgsql-odbc@postgresql.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.