I can read this records without problem, but when I want to make a modification I get the ERROR : "Current Recordset does not support updating.Here is the Dim strquery As String Dim cn As ADODB. Calling the Update method adds the new record to the current Recordset object and resets the Edit Mode property to ad Edit None, but the OLE DB Provider does not post the changes to the underlying database until the Update Batch method is called. When you use arrays of fields and values, there must be an equal number of elements in both arrays. lname ` Restore original data because this is a demonstration. str Cnn = "driver=;server=srv;" & _ "uid=sa;pwd=;database=pubs" Set rst Employees = New ADODB. Open str Cnn ' Open recordset with data from Employee table. As an Access developer — or even as a power user — you won't get far if you can't work with the Recordset object.But it's easy to go astray, and there are a number of mistakes that even experts make.
The OLE DB Provider caches any field value changes locally.Luckily, you can avoid some of the most common mistakes if you just plan for them.However, the possibility means that any Recordset that includes such a field must be able to handle the multiple values.Calling the Update method posts the new record to the database and resets the Edit Mode property to ad Edit None.
If the arguments are passed, ADO immediately posts the new record to the database (no Update call is necessary) and the Edit Mode property value does not change (ad Edit None).
The behavior of the Add New method depends on the updating mode of the Recordset object and whether or not the arguments are passed.