On Mon, 2 Mar 2009 23:39:38 -0800 (PST),
(E-Mail Removed)
wrote:
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
>On Mar 3, 9:27*am, nostradumbas...@yahoo.com wrote:
>> 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 !
Similar Threads
