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

--- Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
>
> Where can we document this information? I don't see
> it on the techdocs
> site.
>

Good question. The available stuff is piecemeal, and
split between techdocs and the odbc site. Joel
Burton's FAQ is the largest, but is incomplete and
appears not to have been worked on much for the last
couple of years. There is the makings of a good FAQ
on the odbc site: perhaps that could be moved to
techdocs, and expanded using reader contributions? I
would be happy to put in some pieces, although I am
sure that there are plenty whose knowledge is much
greater than mine.

Justin?

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

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com