[AccessD] Field Sizes

In SQL you can make everything a VARCHAR(8000) 

:P



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Bartow
Sent: Monday, August 29, 2005 9:20 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Field Sizes


Q: Does it matter when upsizing to SQL Server?  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan

255 characters.

Access doesn't use fixed length storage for strings and you don't save any
space by defining text fields as less than the maximum allowable.  I change
the default field size for text strings to 255 in Options and never change
it for individual filed definitions.

All that restricting field sizes does for you is increase the risk of
truncating data or throwing up error messages at the user sometime in the
future.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com