Current recordset does not support updating adodb klnnar sax viduo co m

After the file is successfully uploaded I want to take the rows in the REGION tab and insert them into an MS Access 2007 table.

This may be a limitation of the provider, or of the selected locktype.

Recordset error '800a0cb3' Current Recordset does not support updating.

Open "select master.isbn,master.location from master where isbn = '" & rs MSsb("ISBN").

Value & "'", cn Ebility, ad Open Dynamic, ad Lock Optimistic, ad Cmd Text Msg Box rs EBMaster("ISBN").

It would be better to use a set-based approach so you import all the worksheet rows as a single operation.

Last modified 21-Sep-2018 10:59