The backend SQL server has recently been upgraded from Microsoft SQL 2008 R2 to SQL2016
An application was unchanged but is now failing to update a recordset.
The ODBC SQLNCLI11 has been in use the past year with SQL 2008 R2.
' Get the transfer record from tblTransfers
strSQL = "tblTransfers"
strSQL = strSQL & " WHERE IMERef = '" & frm.IMERef & "'"
Set rst = New ADODB.Recordset
rst.Open strSQL, gcnn, adOpenKeyset, adLockOptimistic, adCmdTable
' SQL errors should not occur
If rst.RecordCount <> 1 Then
If rst.RecordCount = 0 Then
msg2 = "Cannot find the Transfer record"
msg2 = "More than one Transfer record has been found"
rst!Modifier.Value = [TempVars]![Logon_UserID].[Value]
rst!DateMod.Value = Now()
rst!grossamount = frm.SendAmount 'v9_5_1 for future changes to fields
Code Adding new records works.
Any suggestions for issues associated with an SQL2016?