Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

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

Chapter 10. Programming Access Databases > Working with Database Records: Openi...

Working with Database Records: Opening a Recordset

With all those preliminaries out of the way, you can finally get down to the business of database programming. For the purposes of this chapter, database programming consists of manipulating a recordset, which represents either the records in a table from an Access database or the records that result from a query. In ADO, you use the Recordset object to do all this.

The first thing your procedures will always do is open a recordset. You do that by setting up a connection to a data source, which then gives you access to whatever database was specified when you created the data source. From there you specify the table you want to use, or you set up a query. As you’ll see, ADO handily enables you to do all this with a single statement.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint