Access and field sizes

From: Andrew Perrin - Demography <aperrin(at)demog(dot)berkeley(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Access and field sizes
Date: 1999-10-25 23:49:07
Message-ID: Pine.WNT.4.05.9910251646200.153-100000@random.demog.berkeley.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Greetings-

I'm in the process of porting a database from Access to postgres, and have
run into a snag. The snag involves boolean fields using checkboxes in
Access forms; they always return a useless Microsoftish error:

The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data.

This happens when a checkbox is clicked to set a boolean value to True,
but not when it is clicked to set the value back to False.

Does anyone have any experience or idea where to go with this?

Thanks-
Andy Perrin

---------------------------------------------------------------------
Andrew J. Perrin - aperrin(at)demog(dot)berkeley(dot)edu - NT/Unix Admin/Support
Department of Demography - University of California at Berkeley
2232 Piedmont Avenue #2120 - Berkeley, California, 94720-2120 USA
http://demog.berkeley.edu/~aperrin --------------------------SEIU1199

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-10-26 04:20:41 Re: [SQL] Stats on new tables
Previous Message Zot O'Connor 1999-10-25 19:47:17 Re: [SQL] Week of year function?