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

Chapter 17. From DAO to ADO > Accessing the Data by Recordset

Accessing the Data by Recordset

DAO and ADO use recordsets to access the data itself. In DAO, use the following commands:

Dim db As DAO.Database
Dim rec As DAO.Recordset
 
Set db = CurrentDB
Set rec = db.OpenRecordset("SELECT * FROM tblFilms", dbOpenDynaset)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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