Unbound text box, Text > 255 characters, MSAccess/PostgreSQL

From: Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: <pgsql-odbc(at)postgresql(dot)org>, <pg-interfaces(at)postgresql(dot)org>, <pgsql-interfaces(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
Date: 2005-10-02 23:14:57
Message-ID: 000101c5c8d0$4a2fb340$1f291dc3@zlatkovyfkpgz6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces pgsql-odbc

Hello.
I have the following problem with MS Access/PostgreSQL combination:
There is a form in Access that has an unbound text box, used for entering a commentary of a batch of records.
There is a DAO Append Query that has a parameter that is passed from the text box using parameter of DAO QueryDef object.
I adjusted B7 parameter (Text as LongVarchar) in connection string (ODBC driver) to 1, so that Access links PostgreSQL Text fields as Memo fields in Access. The intention was to be able to enter unlimited length commentary into the field.
But, although I can enter unlimited text by using bound text box in some other forms, in this particular form I can't use bound control, so I need to pass text from UNBOUND control to the linked table by using DAO or ADO code. It seems that DAO query can't accept Memo as parameter, but only text. If my text exceeds length of 255, I have an VBA error 3271. If text in unbound text box is shorter that 255 everything is OK.

So, is there any way to pass text of length >255 from unbound text box to Memo field of linked PostgreSQL table, by using DAO or ADO ?

Thanks in advance,

Zlatko

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Todd A. Cook 2005-10-03 00:16:06 Re: scoring differences between bitmasks
Previous Message Martijn van Oosterhout 2005-10-02 21:13:45 Re: 8.1 'make check' fails

Browse pgsql-interfaces by date

  From Date Subject
Next Message jing han 2005-10-04 13:11:10 how to monitor connections to postgres database
Previous Message David Stanaway 2005-09-27 17:45:38 Re: Synchronize Postgres with an other database

Browse pgsql-odbc by date

  From Date Subject
Next Message Andrus 2005-10-03 18:44:50 Get error message details
Previous Message lothar.behrens 2005-10-01 08:30:56 Re: select count(*) datatype ?