Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Benjamin Scherrey <scherrey(at)proteus-tech(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org,Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
Subject: Re: Can't get more than 255 chars out of memo field in Acc
Date: 2002-11-27 19:07:00
Message-ID: 200211271907.gARJ70v12994@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
Where can we document this information?  I don't see it on the techdocs
site.


---------------------------------------------------------------------------

Benjamin Scherrey wrote:
> 11/27/2002 10:46:51 AM, Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> wrote:
> 
> >This raises an issue for Access developers which, in
> >spite of searching archives, FAQs etc. I have not seen
> >explicitly stated anywhere.
> >
> >I have found that, to be able to use both "text" and
> >"memo" types within Access, linking to tables in a
> >PostgreSQL database, the following must be done:
> >* table definitions in PostgreSQL must use "varchar"
> >for fields desired to be "text" in Access, and "text"
> >for fields desired to be "memo" in Access, and:
> >* "Text As LongVarChar" must be checked in the DSN.
> 
> 	This turns out to be what my problem is I think. I do have the attribute defined as a 'text' 
> type in my postgres table definition but when linked to Access it still appears as 'text' in the table 
> definition. When I try to alter this setting to memo in Access it complains that it "can't save property 
> changes for linked tables". How to I get Access to recognize my Postgres 'text' attributes as memo 
> fields?
> 
> 	thanx & later,
> 
> 		Ben Scherrey
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2002-11-27 19:52:51
Subject: Re: Can't get more than 255 chars out of memo field in Acc
Previous:From: Benjamin ScherreyDate: 2002-11-27 18:24:07
Subject: Re: Can't get more than 255 chars out of memo field in Acc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group