[dba-SQLServer] NVARCHAR turned into Text(255) in Access

JWColby jwcolby at colbyconsulting.com
Wed May 2 08:56:26 CDT 2007


I uploaded my billing database to SQL Server the other day.  The process
worked perfectly AFAICT, however SQL Server turned my memo field into a
nvarchar, which when linked back into ACCESS, was now being converted to a
TEXT(255).  Needless to say, this was not my intention, nor is it
acceptable.  Has anyone ever run into this?  Known solutions?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 



More information about the dba-SQLServer mailing list