John W. Colby
jcolby at colbyconsulting.com
Sat Dec 20 09:11:57 CST 2003
One limitation is that the total data stored in all fields taken together can't exceed a specific value, something like 2Kbytes or 4kbytes (can't remember exactly), not a lot it turns out. That means that (for example) 10 string fields of 255 characters could exceed the value. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: Friday, December 19, 2003 2:34 PM To: AccessD Subject: [AccessD] Property Value I keep getting this message when editing a table definition: Property Value Too Large In many cases the table design is questionable, with over 200 fields in many tables. In addition I have been adding lengthy descriptions to every column in every table. Until this database I have never before encountered this message, and have no idea what is causing it. Could be the number of columns, could be the description length, could be something I haven't considered. The strange thing is that despite this message, my latest changes seem to save OK. Does anyone know what is causing this, or how I might investigate it? Arthur _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com