Changing an existing field to VarChar type also changes the fieldwidth

[nostradumbass77]

I think this is a bug, that hopefully Microsoft can resolve in SP2 !

From an Access 2007 SP1 ADP linked to a SQL 2005 (SP3) database, I
imported tables from an Access 2003 database. The text fields got
imported as NVarChar with the proper widths. However, if I then open
the table design and change the type to VarChar, somehow, the field
width changes to 50. This is surely a bug - why would the field width
change?

Can anyone reproduce this bug and post this on a Microsoft
bugtracker ?

 

[nostradumbass77]

I think this is a bug, that hopefully Microsoft can resolve in SP2 !

From an Access 2007 SP1 ADP linked to a SQL 2005 (SP3) database, I
imported tables from an Access 2003 database. The text fields got
imported as NVarChar with the proper widths. However, if I then open
the table design and change the type to VarChar, somehow, the field
width changes to 50.  This is surely a bug - why would the field width
change?

Can anyone reproduce this bug and post this on a Microsoft
bugtracker ?

I notice that the same thing happens in the SQL Management Studio
table designer... ! This is a serious lapse of quality-control !

 

[Tom van Stiphout]

It's by design. Whenever you change the datatype, the length (if
applicable) goes back to the default.
You would surely call this bad design, but IMHO it is understandable.

-Tom.
Microsoft Access MVP