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.