DWUTKA at marlow.com
DWUTKA at marlow.com
Wed May 26 16:54:01 CDT 2004
That would work. But still is evading the point. Setting text fields to 255 characters isn't giving them all the space in the world, it's just not putting 'extra' limits on something that is already limited to function as is. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock Sent: Wednesday, May 26, 2004 5:51 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] On DB Bloat, Bad DB Design, and various Hi DWUTKA > Not too mention, if you want to argue that, then let's go all the way. Memo > fields are limited to 64k, or the db size limit, if edited through code. So > in 97 you're talking 1 gig, and 2k+ you are talking 2 gig. Might as well > move them to a SQL server, that is hacked into every computer system in the > world, to get as close to unlimited drive space. Or move the text to separate files - as we do for pictures! /gustav > But you are arbitrarily limiting them. In this case to 255. So I'm back to > saying you should set it to memo if you really feel this way. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com