recordset record loking

[bob lambert]

Help

just learning mysql by converting an ms access db to mysql. currently have all tables in mysql backend and still using ms access front end to access and update tables (making conversions for mysql as I go).

in ms access visual basic I open a recordset then use addnew to add new record(s). after adding several records I wanted to queue up 1 at a time in a specific order and add some more info to the records. I found I had to do a recordset requery in order to even see the data just added or else I would get a records deleted error (which they were not). But then after getting past that and queueing up the record I wanted to add more data to , I edited it and changed some values of fields, but when I went to update I got error that someone else was trying to write data at the same time (which they were not).

It seems the records were locked and I dont understand why if I performed an update. It never gave me a problem in access.

what do I have to do to unlock or release the records so I can edit them again ?

Thanks for help

Bob