Error 3251 current recordset does not support updating

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

error 3251 current recordset does not support updating-15

Move Next Loop End If How can I resolve this, why MS Access does allow this simple updating ?

Move Next Loop End If How can I resolve this, why MS Access does allow this simple updating ?

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

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

I have setpped through the code, and the open works, and everything looks ok, but...... You are not adding the last 3 arguments to the rs EBMaster. By not providing them you are opening a forward-only read-only recordset which doesnt support updating. If the Source argument is a select statement then you use the ad Cmd Text argument. Use ad Open Keyset if you are not in a multiuser environment and use ad Open Dynamic if you are and need to see other users inserts and deletes rs EBMaster. The if.command bypasses every single record, even though it finds records. However, I still get the current recordset error message when trying to assign the value to the field I appreaciate all your help to this stage.

Update line I get the error "Recordset does not support updating". ad Cmd Table is specified only when the Source argument is a table name only as in opening the entire table. Okay that is slightly better as it now processes the if.routine.

Hi, My code is working just fine on my computer and I can update the access from my excel.

When trying to do the same from one of my user's computer, I get this error message: "Run-time error '3251': Current Recordset does not support updating.

Open "master", cn Ebility, ad Open Dynamic, ad Lock Optimistic rs MSsb.

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

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

Tags: , ,