Rowset does not support scrolling backward

by

adOpenDynamic is not declared in VBScript and therefore equals Empty, which gets converted to 0 when you assign the CursorType property.
0 is adOpenForwardOnly, and forward only does not support moving backwards, an ability the Find method wants.

You should replace adOpenDynamic with its literal value:

Recordset.CursorType = 2 'adOpenDynamic

To avoid this class of errors altogether, place Option Explicit as the first line of your script.

More Related Contents:

  1. SQL Query output in VBA is different than in SQL Oracle
  2. How to make a parametrized SQL Query on Classic ASP?
  3. Error trying to call stored procedure with prepared statement
  4. Receive an unexpected symbol error in my PLSQL query [closed]
  5. SQL Query to concatenate column values from multiple rows in Oracle
  6. Subquery using Exists 1 or Exists *
  7. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  8. SQL – How to store and navigate hierarchies?
  9. Optimize query with OFFSET on large table
  10. Conditional Count on a field
  11. Update records in table from CTE
  12. single fixed table with multiple columns vs flexible abstract tables
  13. How to insert multiple records and get the identity value?
  14. How can a LEFT OUTER JOIN return more records than exist in the left table?
  15. How to replace (null) values with 0 output in PIVOT
  16. When would I use XML instead of SQL? [closed]
  17. SQL for applying conditions to multiple rows in a join
  18. PLSQL Insert into with subquery and returning clause
  19. How to Optimize Queries in a Database – The Basics
  20. How to resolve SQL0418N Error
  21. Average of multiple columns
  22. combinations (not permutations) from cross join in sql
  23. How to select the first N rows of each group?
  24. ORACLE SQL:Get all integers between two numbers
  25. Insert Dates in the return from a query where there is none
  26. Search an Oracle database for tables with specific column names?
  27. How do I change db schema to dbo
  28. Google Big Query SQL – Get Most Recent Column Value
  29. Bulk insert using stored procedure
  30. How to insert into a table with just one IDENTITY column?

Leave a Comment