Share via

Visual Basic Concepts

  • Article

Remote Data Access Using DAO and ODBCDirect

Visual Basic version offers an additional option that can be used with DAO to access remote database engines: ODBCDirect. This DAO option permits your application to choose the database engine and interface used by DAO. Basically, you have two choices:

  • The Microsoft Jet database engine. By default, DAO uses Jet to perform all data access operations.

  • ODBCDirect. When this option is enabled, DAO loads the Remote Data Objects (RDO) 2.0 libraries and delegates all data access operations to the ODBC data source.

Basically, ODBCDirect maps each of the Data Access Objects to an equivalent Remote Data Object. While not all of the RDO functionality is implemented with ODBCDirect, this approach permits you to leverage existing DAO-based applications using a familiar object model when accessing remote database systems.

For More Information   Information about ODBCDirect’s relationship to RDO is also discussed throughout "Using Remote Data Objects and the Remote Data Control."