MS Access 97 uses type "text" instead of "memo" - Mailing list pgsql-interfaces

From Palmer, Chris
Subject MS Access 97 uses type "text" instead of "memo"
Date
Msg-id 35AB03C74901D2119DAA00A0C9B6A1FB010F3B@EXCHANGE5
Whole thread Raw
List pgsql-interfaces
I recently installed the PostgreSQL ODBC driver for use with MS Access
97.  I can link postgresql tables just fine, but when I try to view the
data, all records with a postgres varchar() type that have in excess of
254 characters cause the record display to generate errors within
Access.  This is being caused by the "text" field type being assigned to
"varchar()" field types during the link.  Is there any way to tell
Access (or the ODBC driver) that varchar() field types should be set to
"memo" field types when Access handles them?

Thanks,

Chris Palmer
chris.palmer@echostar.com

pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Re: [HACKERS] Convert PGconn, PGresult to opaque types?
Next
From: "John Sharp"
Date:
Subject: Is there a pgodbc that works on a Sun Sparc 2.5.1?