From: Jeffrey Silberberg <jsilberberg@mindspring.com>
To: interfaces@postgresql.org
Subject: Text Field will not map into MS Access as Type: Memo
Date: Tue, 11 Apr 2000 18:07:11 -0400
Message-ID: <004801bfa402$4ba297e0$0dc810ac@desktop> (raw)
Help !!! I changed something and can't figure out what : - )
I had a PostgreSQL database on FreeBSD 4.0 Stable, Linked to a
Microsoft Access/97 (Win/95) DB via the PostgreSQL ODBC 6.5.00 driver and
all was working okay. The field "Entry:Text" was mapping across as a
Type:Memo and all of my data was available in reports, with the Can Grow
option on to fit it word wrapped on an activity report.
Well, something has changed, and after updating the Schema and
relinking the Table I can not longer get the Entry:Text to map as anything
other than Text:254 in MSAccess. In fact If I select the Option TEXT as
LongVarChar I get an Error when Linking the Table and can not proceed:
"Invald Fied Definition 'event' in definition of index or relationship. " in
Linking the Table.
With the Field as a 254, I either get Byte 0 to n, or if there are
more than 254 bytes in the field I get 254 + n loosing the first half of my
data....
I am at a loss as to what I broke... Can anyone HELP ??????
TIA,
Jeffrey M. Silberberg
CompuDesigns, Inc.
(770) 399-9464
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jsilberberg@mindspring.com, interfaces@postgresql.org
Subject: Re: Text Field will not map into MS Access as Type: Memo
In-Reply-To: <004801bfa402$4ba297e0$0dc810ac@desktop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox