[AccessD] Field Sizes

On that note, is it good advice to make all text fields VarCHar in SQL
Server?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
dmcafee at pacbell.net

In SQL you can make everything a VARCHAR(8000) 

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

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.