Current recordset does not support updating asp

Rated 4.60/5 based on 725 customer reviews

To avoid this type of error, give priority to the library that your code references the most.In the Visual Basic Editor, choose References from the Tools menu, highlight the main library, and click the up button to position it above the other object library.If you expect the Recordset to contain records most of the time, it's more efficient to include Not in the check.

Update 'Re-run the Query once the database has been updated .If both properties are True simultaneously, the Recordset is empty.Tip: Including the Not operator is a matter of efficiency.When both libraries are referenced and both libraries support an object, VBA will assign the library with the highest priority. Explicitly referencing each object's library when you declare the object is better: Moving through the records in a Recordset is a common task, but doing so comes with a few hazards.Using any move method will generate an error if the Recordset object is empty.

Leave a Reply