Share via


Visual Basic Concepts

Using Data Access Objects with Remote Databases

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.

Topics

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.