Category Archives: MS Access

Query “query name” is corrupt in MS Access

Everyday IT issues, MS AccessBy Chrysostomos Psaroudakis November 22, 2019

A MS Office update posted on the 12th of November 2019 has caused several queries to fail with no reason. If you are running on Office 365, then proceed with the latest Office 365 update. If you are running other versions of MS Office then: If you have installed any of the following (according…

Msg 8152, Level 16, State 10 String or binary data would be truncated. The statement has been terminated.

Everyday IT issues, MS Access, SqlBy Chrysostomos Psaroudakis February 14, 2017

It appears that when you want to “insert into” data from an nvarchar(max) field to another nvarchar(max) field, and the table has a lot of data the ms sql query is terminated giving you the error Msg 8152, Level 16, State 10 String or binary data would be truncated The statement has been terminated. After…