• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Defining Fields and Records ... > Understanding ADO Recordset Types

Understanding ADO Recordset Types

ADO also uses different sorts of recordsets, but they're defined differently than DAO recordset types. The two principal ways to specify an ADO recordset's properties are by setting them directly or as part of the recordset's Open method. For example

Set rsProcs = New ADODB.Recordset
With rsProcs
  .Source = "Procedures"
  .ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "Data Source=" & SourceFile
  .CursorType = adOpenDynamic
  .LockType = adLockOptimistic
  .CursorLocation = adUserServer
End With


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint