Believe it or not there is not a KB article on this at http://support.microsoft.com/support
Reduce this column size by one character in SQL Server database if the frontend is Access 97.
Although the Microsoft Upsizing Wizard will successfully upsize field text (255) to nvarchar(255) you will get problems with the linked table. When you view the data it will give #error for the whole record.