Re: Access 2000 bitching... "The field is too small to

From: "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov>
To: <philippe(dot)lang(at)attiksystem(dot)ch>, <ptbense(at)gwm(dot)sc(dot)edu>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Access 2000 bitching... "The field is too small to
Date: 2005-05-17 16:23:19
Message-ID: s289b820.094@groupwise.abag.ca.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

It's a kludge, but you can successfully use boolean postgres variables in Access.

To link a form with bound check boxes to a postgres table, link to the table with an odbc driver with 'bool as char' unchecked and 'true is -1' checked.

To run queries against a postgres table with boolean fields, use a second odbc driver (which will link to the same table under a different name) with 'bool as char' checked and 'true is -1' unchecked, and in the query use "1" and "0" as the true and false values (ie, use variable = "1" in place of variable=true).

It's only a slight pain to link with two driver configurations, and is has been working for me without difficulty for two years now.

Fred

>>> "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch> 05/16/05 11:05 PM >>>
I'm not sure really, but it might by a problem with a DATE field that receives TIMESTAMP data. Try casting.

Otherwise, avoid BOOLS with a MS Access front-end... Use INT2 instead.

Hope this helps

Philippe

-----Message d'origine-----
De : pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] De la part de Peter Bense
Envoyé : mardi, 17. mai 2005 00:07
À : pgsql-odbc(at)postgresql(dot)org; jeff_eckermann(at)yahoo(dot)com
Objet : Re: [ODBC] Access 2000 bitching... "The field is too small to

I'm not at work right now so don't have the exact details available, BUT...

1. I am not using check boxes.
2. When I insert data into the table via PSQL it displays fine in the view itself. The error occurs when I try to insert. The user does have all the necessary privileges, etc. I have verified that part about 10 times.
3. I have not changed any of the odbc settings (as you mention) from their default values.

./peter

Peter T. Bense - Teradata Certified Professional
(ptbense(at)gwm(dot)sc(dot)edu) - 803-777-9476
Database Administrator/Webmaster
Prevention Research Center
University of South Carolina
>>> Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> 05/16/05 4:47 PM >>>

--- Peter Bense <Ptbense(at)gwm(dot)sc(dot)edu> wrote:
> I am getting a
>
> "The field is too small to accept the amount of data
> you attempted to
> add" postgresql error when attempting to enter data
> into the following
> linked table in MS-Access. Nothing seems to be out
> of range. Any
> ideas?:

I assume you are using check boxes? This has been a
frequently encountered problem for Access users.

I adopted a specific workaround a while ago, then
forgot about the problem. But before I recommend that
workaround, let's make sure that time has not revealed
a better way. What are your driver settings for
"bools as char" and "true is -1"?

>
> CREATE TABLE tblpis_survey_receipt (
> insertion SERIAL,
> ppt_id INT4 NOT NULL,
> date_received DATE NOT NULL,
> staff_id INT4 NOT NULL,
> survey_type INT2 NOT NULL,
> is_blank BOOL NOT NULL,
> birth_month INT2,
> birth_year INT2,
> check_ppt BOOL NOT NULL,
> check_dob BOOL NOT NULL,
> check_tracking BOOL NOT NULL,
> date_inserted TIMESTAMP WITHOUT TIME ZONE NOT
> NULL,
> date_modified TIMESTAMP WITHOUT TIME ZONE NOT
> NULL,
> PRIMARY KEY (insertion)
> );
>
>
> Peter T. Bense - Teradata Certified Professional
> (ptbense(at)gwm(dot)sc(dot)edu) - 803-777-9476
> Database Administrator/Webmaster
> Prevention Research Center
> University of South Carolina
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
>


__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
joining column's datatypes do not match

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Browse pgsql-odbc by date

  From Date Subject
Next Message Peter Bense 2005-05-17 19:14:00 My MS-Access problem keeps getting weirder and weirder...
Previous Message HaMaD H 2005-05-17 15:32:56 CrAz88Girz (^_^)