Visual Basic Concepts
Data Access Objects (DAO) can be used either with the Microsoft Jet database engine or, using the ODBCDirect option, without it. This chapter discusses design and implementation issues that arise when using the Data Access Objects (DAO) to access remote databases.
You may find the Jet Database Engine Programmer's Guide and Hitchhiker's Guide to Visual Basic and SQL Server (both published by Microsoft Press) useful sources of information on using DAO to access ODBC data sources using Jet.
DAO Remote Data Access Using Jet
Provides a brief overview of remote data access with DAO using the Jet engine. |
|
Managing DAO ODBC Users
Briefly summarizes issues such as capacity, security, and maintenance. |
|
Managing DAO Network Traffic
Outlines designing and debugging with network capacity in mind. |
|
Managing DAO ODBC Connections with Jet
Outlines issues relevant to opening a connection to an ODBC data source with the Jet engine. |
|
Choosing a DAO Query Processor for Use with Jet
Overviews issues relevant to performing queries on remote databases with the Jet engine. |
|
Building DAO Cursors with Jet
Lists and describes cursors supported by the Jet engine. |
|
Using DAO to Share Remote Data
Briefly describes issues relevant to sharing a database among users and applications. |
|
Handling Remote DAO Messages and Errors
Outlines issues involved in handling errors during DAO remote database access. |
|
Remote Data Access Using DAO and ODBCDirect
Briefly describes the ODBCDirect option, which maps DAO to Remote Data Objects. |