Cannot located row updating

When I try to update record, I kept getting this error: Row cannot be located for updating.Some values may have been changed since it was last read. from Access/MSSQL databases to My SQL and the same code works for both accept My SQL. Tks John When I try to update record, I kept getting this error: Row cannot be located for updating. The solution is also mentioned on this page about making My SQL & My ODBC work with MS Access: another reference, more complete with screen shots of the proper way to set up the My ODBC DSN for MS Access: Gui...Regards, Bill K. I've tried below and none works - I am using My ODBC to access My SQL not MS Access. I tried change OPTION=2 as suggested in still get the same error.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).No other users are accessing the database - only 1 user is accessing the database. Some values may have been changed since it was last read. from Access/MSSQL databases to My SQL and the same code works for both accept My SQL. Tks John Here's a topic in the My SQL docs that addresses this issue: need to enable the "Return Matching Rows" option in My ODBC. Do you know where I can find the documentation for all the options for connection string? The solution is also mentioned on this page about making My SQL & My ODBC work with MS Access: another reference, more complete with screen shots of the proper way to set up the My ODBC DSN for MS Access: Gui...Regards, Bill K. You mentioned MS Access, so I assumed you are still using Access as a front-end to My SQL.No other users are accessing the database - only 1 user is accessing the database. Tks John "Bill Karwin" Here's a topic in the My SQL docs that addresses this issue: need to enable the "Return Matching Rows" option in My ODBC. I've tried below and none works - I am using My ODBC to access My SQL not MS Access. I tried change OPTION=2 as suggested in still get the same error.Recordset, obj Contact As Object, str ID As String) On Error Go To Err_Update Contact Dim db As DAO. Recordset ' rs Fields contains the names of the fields for synching Dim qdf As DAO. Query Defs("qry Fields For Contacts") Set rs Fields = qdf.Query Def Dim i As Boolean Dim str Text S, str Item S As String Dim str Text O, str Item O As String Dim lng Index O As Long Dim old As String Dim str SQLUpdate As String Dim obj Items As Outlook. Open Recordset Update Contact = False ' Assume it did not update... Sugar Field Name If str Item S str Text O Then old = """" ' sets up the SQL text delimiter character...

; microsoft.support.content = (function(){ return { "click Tale Configuration": , "Internal Content Config": , "Mwf Configuration": , "Rps Sign In Info": , "Site Content Config": { "Link Farm Enabled": true, "One Site Service Uri": "https://uhf.microsoft.com//shell/xml/?

Leave a Reply