I recently came across a problem that was difficult to diagnose. After I had changed the datatype in a table from varchar(256) to varchar(512) my Access 2013 reports show data truncated to 256 characters. It turned out that the views that I’d created against the base table were truncating the field.
After changing the datatype in a table it is necessary to drop and re-create any views that reference it. This is very easy to do by scripting out the view and executing the script.
- Drop and re-create dependant views after changing datatypes