Row cannot be located for updating vb6 access

Row cannot be located for updating vb6 access

Question TWO I have on and off been using Basic, now VB since “the stone age” long before Microsoft and Windows.

However it is only now I enter the issue of using VB6 and a database.

This maybe a limitation of the provider,or of the selected locktype " I am using the code below for my update: Set rs = New ADODB. Open "Access", Con, ad Open Forward Only, , ad Cmd Table If Not txt User Number. Also, the Filter method works better for me in this context than the Find method. Especially when you contradict someone else who is trying to help too. This post has been edited by Bob Rodes: 07 April 2013 - AM Private Sub Command1_Click() Dim cn As Connection Dim rs As Recordset Set cn = New Connection cn. Are you saying that you check everything that you post and don't make mistakes?

This means that your recordset is "dirty" between requeries if you don't do it every time you change a record, and doing that can cause unacceptable performance overhead if you are working with a lot of records. (Last one had to do with a less-than-complete understanding of how cursortype and cursorlocation interact, as I recall.) You have an impressive range of expertise and people listen to you. Especially when you contradict someone else who is trying to help too. Wow, sounds very much like you've been saving this up.

I am running VB6, Microsoft ADO 2.5, My SQL 5.0, and "DRIVER=;".

Comments