Using the following code to supply data to a form using SQL Server Express 2012 Allows data editing on the resulting form.
Using the same code with connection to SQL Server 2008 Express causes the data to be read only in the form.
90 Set rs_Temp = New ADODB.recordset
100 With rs_Temp
110 Set .ActiveConnection = rs_Cnn
120 .Source = SQLStatement
130 .CursorLocation = adUseServer
140 .LockType = adLockOptimistic
150 .CursorType = adOpenDynamic
160 .CursorLocation = adUseClient
180 End With
190 Set FormRS = rs_Temp
What am I missing? An SQL Server security setting?