Access 2000 bitching... "The field is too small to accept the amount of data you attempted to add"

From: "Peter Bense" <Ptbense(at)gwm(dot)sc(dot)edu>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Access 2000 bitching... "The field is too small to accept the amount of data you attempted to add"
Date: 2005-05-16 18:17:05
Message-ID: s288ab6d.008@gwm.sc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

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

Browse pgsql-odbc by date

  From Date Subject
Next Message Jeff Eckermann 2005-05-16 20:47:54 Re: Access 2000 bitching... "The field is too small to accept the amount of data you attempted to add"
Previous Message Gulf Sun 2005-05-16 10:21:11 CrAz88Girz ---> <--