Every time user adds/deletes/sorts/drags node, I have to update their viewing index in db. Every time user adds a node and the treeview has, say, 10 nodes, it is taking 10-20 seconds ! My problem is, this Requery process is painfully slow.
Good stuff Could you mark the thread as resolved please?
(on the Thread Tools menu above) My guess is that the standard behaviour of Find invalidates the recordset, as it filters it (and as such effectively creates a new recordset).
Description: When I try to update a record but there are no changes in the record the update fails with the following error text: "Row cannot be located for updating. 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". Left on it's own, *Access* forms rather insane update queries depending on *all* fields values, timestamps and who knows what.
Some values may have been changed since it was last read." As far as I can see there are two work-arounds: 1. First check if there are changes in the record How to repeat: rs. Conn, Cursor Type Open Keyset, Lock Type Lock Pessimistic) With rs . Same problem here, My SQL ODBC Driver 5.1 Access 2007, vba code .update doesn't work when the value is already in the table. Please try to tell Access how to form UPDATE queries as described above: rs Customers. Value = ad Criteria Key and catch any error it might throw.
Always Run-time error '3197' The Microsoft Office Access database engine stopped the process because you and another user are attempting to change the same data at the same time. .update works fine when it runs for the first time. If you omit this, you'll just end up with updates really failing cause Access tried to exact-match floats, blob's and so on.
As of second time -Rob, Klaus, as stated in original report (Bug#7160), I will really need ODBC trace from Driver Manager to see what's actually happening. As for error being thrown, it is rather straight forward...
Open "SELECT * FROM Customers", cn NWind, _ ad Open Static, ad Lock Optimistic, ad Cmd Text rs Customers. No feedback was provided for this bug for over a month, so it is being suspended automatically.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site.
If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.