I should add, of course all the other items (re-)save perfectly, there is
nothing about that actual record which is different.
MySQL 5.0.27 WinXP
Set mconn = New ADODB.Connection
mconn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" & "SERVER=" &
mstrServerName & ";" & " DATABASE=" & mstrThisDatabase & ";" & "UID=root;PWD="
& mstrThisPassword & "; OPTION=3"
mconn.Open
mconn.CursorLocation = adUseClient
grsOrderItems.Open mstrSQL, mconn, adOpenStatic, adLockOptimistic
Jonathan
>Hi Everyone
>I am using VB6 and MySQL, recently installed. I have a FlexGrid of items. I
>save them, and in a large order (25 or more) there will be at least one which
>causes an error "Row cannot be located for updating. Some values may have been
>changed since it was last read." The values looked up have not changed, the
>only change might be price or quantity. I tried looking the order items up on
>their unique record number (primary key), then I tried on their order number,
>item name and colour (a unique set of values). It's always the same item(s) in
>a given order, but for different orders it will not be the same item, colour
>or row number as other orders.
>I've been onto Google and found some stuff about Option=2 but that didn't make
>any difference.
