Enterprise architect row cannot be located for updating Camsex online
The following section details some common errors and their suggested fix or alternative solution.
If you are still experiencing problems, use the Connector/ODBC mailing list; see Section 9.1, “Connector/ODBC Community Support”.
Many problems can be resolved by upgrading your Connector/ODBC drivers to the latest available release.
On Windows, make sure that you have the latest versions of the Microsoft Data Access Components (MDAC) installed.
While it may seem a bit odd, not all ADO cursor types are capable of maintaining an accurate record count.
Cheers / Fred Hi Fred, Your record count is -1 because you are using a dynamic cursor.
The BETA software is provided "as is" without warranty of any kind, either expressed or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose.If the recordset's data source actually contains a field named "ID", I can't think of any reason why you would'nt be able to reference it using "rs1! Post some code that occurs earlier in your module, such as connection and recordset object configurations if you like. Plus you can get a record count because you're cursor is static. Open Recordset("qry_stock", db Open Dynaset) 'Opens connection to Whapp cn1. Rather than report an erroneous record count (their may be recently added records in the underlying data source whose keys are'nt included in the dynamic cursor), ADO just returns -1.For more information, see Can't connect to [local] My SQL server.The following error is reported when using transactions: .