The Access ODBC driver lets you open an MDB file without using Microsoft Access. The Access ODBC driver enables applications that support ODBC to connect to an MDB file on Linux and UNIX machines (platforms on which Microsoft Access is not available). The ODBC-ODBC Bridge provides an alternative way to connect ODBC applications to an MDB file on Linux and UNIX platforms. These two products are described here.
Both the Access ODBC driver and the ODBC-ODBC Bridge can also open an ACCDB file, the database file format introduced in Microsoft Office Access 2007.
Access has four components:
Access data is stored in a database file, which has the extension .mdb.
A DBMS-based ODBC driver accesses the data in a database through a separate database engine. Microsoft's Access ODBC driver is a DBMS-based ODBC driver that accesses an MDB file through the Jet Database Engine. (The ODBC-ODBC Bridge uses Microsoft's Access ODBC driver to connect to an MDB file.) A file-based ODBC driver accesses the data in a database directly. Our Access ODBC driver is a file-based ODBC driver that can connect to a MDB file that is visible through the local file system on the machine where the driver is installed.
ODBC drivers support SQL, the database query language that Access generates in Query Design View or lets you enter directly. Some ODBC applications, for example OpenOffice.org Base, provide a graphical interface that let you interact with the Access database in a similar way to the Access front end application.
© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.
