John Bartow
john at winhaven.net
Mon Dec 5 20:36:22 CST 2005
I've been thinking about this a bit and I think probably the biggest reason I don't do the 255 for everything is because I wasn't raised on Access. It made a difference in the other DBs I've interacted with. And I suppose since a lot of what I've done in Access was brought over from another format I've always figured it would end up in something else before it was all over. OCD? Maybe. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow Sent: Monday, December 05, 2005 3:37 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Why Change Field Size/was Change Field Size I think in essence I agree with you on the point: If I don't know what the length will be for sure then I do 255. Otherwise, and generally the case, is that I specify. Why? OCD. :o) And it takes little extra effort to do and can pay off in the future if you decide to to interact with other RDBMS's. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com