Access vba current recordset does not support updating

Posted by / 11-Oct-2020 14:49

Recordset Dim str SQL As String Dim my DB As String Dim cn As Object On Error Go To Error Handler Set cn = Create Object("ADODB.

Connection") my DB = "X:\COMMERCIAL\New Automated Invioce Tracker\Commercial_Invoice_Tracker.accdb" cn.

This may be a limitation of the provider, or of the selected locktype." Here is the relevant part of the code: ********************************************** Dim cn As ADODB.

OLEDB.12.0; Data Source=\IP\referantim\System Change Requests\Requests_Management_File.accdb; Persist Security Info=False;" cn.

Open "Requests", cn, ad Open Keyset, ad Lock Optimistic, ad Cmd Table With rs .

; microsoft.support = microsoft.support access vba current recordset does not support updating-88access vba current recordset does not support updating-73access vba current recordset does not support updating-22

Close str SQL = "SELECT * FROM [CT] WHERE [Invoice_ID] = " & Me.