dao advanced programming
by dan haught
vice president of product development
http://www.fmsinc.com
introduction
data access objects, or dao, is a powerful programming model for database services. originally designed as an odbc layer for microsoft visual basic version 2.0, dao has evolved into a model that encompasses microsoft jet and odbc, and in the future, oledb. this session covers advanced topics in dao programming that will give you the tools you need to become an advanced programmer using the dao model.
this session is of primary value to developers creating database applications using microsoft access, microsoft visual basic, microsoft excel, or microsoft visual c++.
some of the material here is based on work done for the "microsoft jet database engine programmers guide" from microsoft press (isbn 1-55615-877-7). this book is the most complete reference for dao and jet programming.
the following topics will be discussed:
- a quick overview of dao
- object creation and modification
- working with data
- developing an object dictionary
- semi-documented tools and resources
- wrapping up
back to main technical papers page
copyright 1996 fms, inc. all rights reserved
a quick overview of dao
up until dao 3.1, dao was defined as:
"the programmatic interface to microsoft jet".
jet is the database engine used by microsoft access and microsoft visual basic. dao has historically been synonymous with jet, in that jet was the database engine that it mapped to. as of dao version 3.1, an important change has occurred. dao 3.1, through the odbc-direct extensions, offers for the first time the ability to completely bypass microsoft jet. it is because of this important new functionality that at a conceptual level, dao is no longer tied to jet. it is now defined as:
"a programmatic interface for database services"
