The table it tries to update has an Identity column. Post by fniles I am using VB6 connecting to a SQL Server 2005 database using ADO. Some values may have been changedsince it was last read).I am using Lock Typead Lock Optimistic and cursor Type ad Open Keyset. The table it tries to update has an Identity column. This is usually due to a lack of a primary key on the table.Hello, I have a legacy application written in VB6 and using Oracle OLEDB Provider (version 9 and updated to the last ones from oracle site) I've a problem during insert of a record using recordset method (Add New).Is there a requirement for users to work while disconnected from the corporate network?Helpful for debugging and validating your SSL configuration.One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.I am using VB6 connecting to a SQL Server 2005 database using ADO. Some values may have been changed since it was lastread). Update method I get the error -2147217864 (Rowcannot be located for updating.
That chapter Ilinked to also covers this topic.--Microsoft MVP -- ASP/ASP. The email account listed in my Fromheader is my spam trap, so I don't check it very often.Hi, I'm trying to update a My SQL database, very simple table, but keep getting this message. The table has 11 fields, the first (fld ID) being an Int set to auto_increment.All the others are varchar(50) and set to allow Null.I'm probably missing something simple, but any help would be great.
Here's the code: Scans your site and returns information about your SSL implementation and certificate.
I am using Lock Type ad Lock Optimistic and cursor Type ad Open Keyset. If your tabledoes have a primary key, the problem can also be caused by not including theprimary key field(s) in the select clause of the query used to open therecordset.