Hi Everyone I am using VB6 and My SQL, recently installed. 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.
The error I get is: OLE DB provider "MSDASQL" for linked server "TEST" returned message "Row cannot be located for updating.Once completed troubleshooting, start the service back up again. Run the coredbutil program and click the button to Build Components.7. Notes: The dbrepair program can be downloaded here: update metaobjattrrelations set tablename = 'Client Sec Sol' where tablename = 'UNMODELEDDATA' and metaattributes_idn = (select metaattributes_idn from metaattributes where def = 'Fingerprint Reader Detected') If the result that says “1 row affected”, The Inventory Service on the LANDesk Core Server MUST be restarted.First make sure the is properly registered by doing the following steps on the LANDesk Core Server: 1. In the command prompt browse to \Program Files\Landesk\Management Suite3. Ensure it states the dll register succeeded Next run dbrepair to clean up unmodeled data and coredbutil to check the database structure. Additional Troubleshooting: If the error description contains a table other than Unmodeled data then it is possible there are metaattributes pointing to nonexistant columns.Some values may have been changed since it was last read." As far as I can see there are two work-arounds: 1. Update() End With If the information in the database is the same as what's in the update then the error occurs. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".Catch error https://support.microsoft.com/en-us/kb/300586 number -2147217864 2. First check if there are changes in the record How to repeat: rs. Conn, Cursor Type Open Keyset, Lock Type Lock Pessimistic) With rs . [ ] Klaus Lozie Same problem here, My SQL ODBC Driver 5.1 Access 2007, vba code .update https://bugs.mysql.com/bug.php? [ ] Miguel Solorzano Bug: hfrom Google Sign in Hidden fields Search for groups or messageshere for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.