Skip site navigation (1) Skip section navigation (2)

Access 2000 bitching... "The field is too small to accept theamount 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 theamount of data you attempted to add"
Date: 2005-05-16 18:17:05
Message-ID: s288ab6d.008@gwm.sc.edu (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group