Jim Dettman
jimdettman at earthlink.net
Fri May 21 15:47:31 CDT 2004
Arthur, You need to fill the fields since text fields are stored variable length. Also, for JET 4.0 (A2K and up), the page size was increased to 4096 bytes because of Unicode requiring 2 characters. The error you get is "Record Too Large" Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: Friday, May 21, 2004 4:32 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] On DB Bloat, Bad DB Design, and various Having never heard this before, I created an Access table with 9 text (255) fields and successfully added a row. Then I decided to add some more fields to the table, all text 255. I quit at 20, where I was able to add and edit a row. This is Access 2002 so your results may differ. In this version, the 2k limit is no longer. The database is Access 2000 style, so this must have been true then too. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jürgen Welz Sent: Friday, May 21, 2004 2:02 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] On DB Bloat, Bad DB Design, and various "Unnecessary" size restrictions on fields ensure that a record can be saved. If you have more than 8 text fields at 255 characters per field, Access will refuse to save the record. Have you forgotten the the 2k character limit on record size in mdb files? Ciao Jürgen Welz Edmonton, Alberta jwelz at hotmail.com >From: DWUTKA at marlow.com > >Actually I think that talking about Access training/experience is a >valid topic. > >Recently, I have helped a friend with his Access 'homework' from his >MIS course. I worked cheap (for beer <grin>), but it just kills me >what they are having students do. The 'instructions' for the >assignments has them naming tables with spaces, setting unnecessary >size limitations for text fields, etc. Just plain ugly. In fact one >instruction was so goofy, I completely bypassed what they were trying >to do, and wrote some VBA to have the same result. > >It is just flat out amazing that the world moves as it does. <grin> > >Drew _________________________________________________________________ MSN Premium includes powerful parental controls and get 2 months FREE* http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU =http://hotmail.com/enca&HL=Market_MSNIS_Taglines -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com