> -----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.