Restricted data type attribute violation (#0)

Shaftsbury

New member
Local time
Today, 07:56
Joined
Feb 10, 2009
Messages
7
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?:confused:
 
might be something to do with a "bit" attribute (yes/no) - but not really sure,
 

Users who are viewing this thread

Back
Top Bottom