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:

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)
