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

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

From

"Peter Bense"

Date:

16 May 2005, 18:17:23

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@gwm.sc.edu) - 803-777-9476
Database Administrator/Webmaster
Prevention Research Center
University of South Carolina