Restricted data type attribute violation (#0)

[Shaftsbury]

Full error:

Run-time error '3146'

ODBC --call failed.

[Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation (#0)

The error occurs when trying to run the following code:

DoCmd.OpenReport "rptMaster", acViewPreview, , "[Div1] = '" & strDept & "' And [NCRStatus] <> '" & strClosed & "'"

The report was loading fine for months until just recently when the error started appearing.

2 things to consider:

• The IT department has been working on the SQL server
• we recently upgraded to access 2016 from 2013 (I ended up rolling mine back to 2013 because of compatibility issues)

Any ideas?

 

[gemma-the-husky]

might be something to do with a "bit" attribute (yes/no) - but not really sure,