Ray - I went with your third option - created a Maintanance backup Plan, so far so good. Thanks for the quick response.

Yes recreating the views and relinking in Access worked, I stumbled on this same solution the other day. I also had to recreate stored procedures since they were defined with...

I just checked the linked views - they are the ones causing the problem I think, they show Field size of 7 instead of 10. I tried deleting and relinking...

Yes, the tables in access are links to the SQL Server database but they show the correct field sizes (the updated lengths)