Обсуждение: Re: Access 2000 bitching... "The field is too small to accept the amount of data you attempte
Re: Access 2000 bitching... "The field is too small to accept the amount of data you attempte
От
Jeff Eckermann
Дата:
--- Peter Bense <ptbense@gwm.sc.edu> wrote: > I'm not at work right now so don't have the exact > details available, > BUT... > > 1. I am not using check boxes. I asked about that, because the error you saw frequently comes up with check boxes. So, if you are not using check boxes, how are the boolean fields being displayed/edited? > 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. Try setting "true is -1" to true. I believe that option was introduced specifically as an Access compatibility switch. > > ./peter > > Peter T. Bense - Teradata Certified Professional > (ptbense@gwm.sc.edu) - 803-777-9476 > Database Administrator/Webmaster > Prevention Research Center > University of South Carolina > >>> Jeff Eckermann <jeff_eckermann@yahoo.com> > 05/16/05 4:47 PM >>> > > --- Peter Bense <Ptbense@gwm.sc.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@gwm.sc.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@postgresql.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 > > Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html