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