Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

Rowset does not support scrolling backward.

I have Access front end and a SQL backend.
I have DAO code that I'm trying to change to ADO code.  
I have the attached code snippet and I'm betting the error...
     Rowset does not support scrolling backward.
Is that because my syntax is still wrong?
Thanks

Set rs1 = New ADODB.Recordset
    cn.Open "Provider=SQLNCLI;Server=10.0.0.10\SQLExpress;Database=FDThomasQC;Trusted_Connection=yes;"
    rs1.Open "SELECT WorkReleaseID FROM tblWorkRelease WHERE WorkReleaseID = " & cboReleaseNo, cn
    rs1.MoveFirst
    rs1.Find "[WorkReleaseId] = " & cboReleaseNo.Value  'GET ERROR HERE

Open in new window

0
BobRosas
Asked:
BobRosas
1 Solution
 
Daniel WilsonCommented:
http://www.w3schools.com/ADO/met_rs_open.asp
rs1.Open "SELECT WorkReleaseID FROM tblWorkRelease WHERE WorkReleaseID = " & cboReleaseNo, cn, adOpenKeyset
   
0
 
BobRosasAuthor Commented:
That worked.  Thanks!
Also thanks for the link.  Lots of useful info.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. 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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now