Current recordset does not support updating fresh online dating sites
This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. I am getting the following error message when trying to update recordset in "While" looping: Current Recordset does not support updating. Recordset") s SQL = "SELECT * from Contents WHERE Parent = " & i Parent & " AND Ordr in(" & i Node & "," & i Node After & ") ORDER BY Ordr " 'Response. Open s SQL, obj Conn, ad Open Keyset, ad Lock Pessimistic ' ad Open Keyset Cursor Type - A.
This may be a limitation of the provider, or of the selected locktype(Although the record get updated when I update single record).
We definitely prefer not to do that, we would much rather be answering questions instead... not everyone is the mvp As I said in the second half of the sentence you quoted, your mistake was understandable - and I would far rather you hadn't decided to turn it into an argument, but that was entirely your choice.
Clearly the FAQs don't always contain the answers, but if they do then they are generally better than a reply to a thread - because those of us who write FAQ articles typically spend about 50 times as long writing them (including checking documentation, testing code, searching previous threads for alternate solutions/caveats, etc). take it easy on the people asking questions geek man.
The exceptions (which arguably fit in either) are when people are writing VBA code to interact with a database.this may be a limitation of the provider" Dim cn As New ADODB.Recordset Dim db As Variant Dim str SQL As String Dim w Sheet Name As Variant db = "\SIMPLAN-SWATHI\Users\mgt\dbdata.accdb" //Network DB path cn.Access 2007 introduced major new functionality in both the engine and the interface.Seasoned developers discovered new things are possible, and casual users found more things within their grasp.