pendahuluan DAO

When Visual Basic first started working with databases, it used the Microsoft Jet database engine, which is what Microsoft Access uses. Using the Jet engine represented a considerable advance for Visual Basic, because now you could work with all kinds of data formats in the fields of a database: text, numbers, integers, longs, singles, doubles, dates, binary values, OLE objects, currency values, Boolean values, and even memo objects (up to 1.2GB of text). The Jet engine also supports SQL, which database programmers found attractive.
To support the Jet database engine, Microsoft added the data control to Visual Basic, and you can use that control to open Jet database (.mdb) files. Microsoft also added a set of Data Access Objects (DAO) to Visual Basic:

•  DBEngine—The Jet database engine

•  Workspace—An area can hold one or more databases

•  Database—A collection of tables

•  TableDef—The definition of a table

•  QueryDef—The definition of a query

•  Recordset—The set of records that make up the result of a query

•  Field—A column in a table

•  Index—An ordered list of records

•  Relation—Stored information about the specific relationship between tables

We’ll work with these Data Access Objects in the next chapter; in this chapter, we’ll work with the data control.