Access ODBC driver
ODBC driver for Access databases (MDB and ACCDB)
The Easysoft Access ODBC driver connects 32-bit and 64-bit applications on Linux and UNIX to Microsoft Access databases.
To ensure compatibility with databases created in as many versions of Access as possible, the Access ODBC driver supports both the MDB and ACCDB database formats. The Access ODBC driver can connect to MDB databases created in Access 2000–2003 and later. The Access ODBC driver can also connect to ACCDB databases, which is the default format for databases created in Office Access 2007 and later. The Access ODBC driver is a flexible, future-proof solution therefore, which will integrate Linux and UNIX with whatever version of Access suits your organisation best.
The Access ODBC driver provides read-write access to Access databases, so your Linux and UNIX applications can update as well as retrieve Access data. If you need to restrict users to read-only access, you can configure the driver to open the database in read-only mode, just as you can with the Access front-end application on Windows.
Choosing the Access ODBC driver to connect Linux and UNIX with Access will not disrupt your existing Access solution's environment or users. There is no software to install on your Windows machines. You do not need to change where your database file is located. The Access ODBC driver can open an Access database stored on a Windows share, so there is no need to copy the database file to your Linux and UNIX machine. To ensure concurrent access to the database by Windows and Linux or UNIX users is problem free, the Access ODBC driver uses Access' locking file mechanism. The driver will also prevent its users from opening a database if another user has the database opened for exclusive access, again mirroring the Access front-end's behaviour for seamless integration.
The Access ODBC driver supports encrypted or encoded MDB files, which is an Access security feature that protects Access data from unauthorised viewing. When you use the Access ODBC driver to load a remote MDB file, encrypting or encoding the database protects the privacy of the Access data as it is sent across the network.
To ensure compatibility with multiple Linux and UNIX applications, the Access ODBC driver supports the unixODBC Driver Manager. Most (if not all) Linux and UNIX applications support unixODBC, which, as a mature, non-proprietary, robust Driver Manager, is part of the standard installation of many Linux distributions. To provide a self-contained solution, the Access ODBC driver distribution itself includes the unixODBC Driver Manager. To get you going quickly, the Access ODBC driver automatically installs itself into unixODBC, making the driver immediately available to your applications.
Platforms
The Access ODBC driver is currently available on these platforms:
| Version | Platform | Distribution |
|---|---|---|
| v1.4 (Access 2000 - 2019) | Linux (x86) (64 - Bit) | (kernel 2.6-6.0+, glibc 2.3.5+) |
| v1.3 (Access 2000 - 2019) | AIX (PPC) (64 - Bit) | (5.0-7.2) |
| v1.3 (Access 2000 - 2019) | Linux (x86) (32 - Bit) | (kernel 2.2-4.0+, glibc 2.1+) |
| v1.3 (Access 2000 - 2019) | Solaris (Sparc) (32 - Bit) | (2.6-2.11) |
| v1.3 (Access 2000 - 2019) | Solaris (Sparc) (64 - Bit) | (2.8-2.11) |
| v1.2 (Access 2000 - 2019) | Linux (ARMv71) (32 - Bit) | (Raspberry Pi, kernel 4.9.41-v7+, glibc 2.24+) |
| v1.2 (Access 2000 - 2019) | Linux (Itanium i64) (64 - Bit) | (kernel 2.4-3.0+, glibc 2.2.5) |
| v1.1 (Access 2000 - 2013) | AIX (PPC) (32 - Bit) | (4.3-7.2) |
| v1.1 (Access 2000 - 2013) | HP-UX (Itanium i64) (32 - Bit) | (11i) |
| v1.1 (Access 2000 - 2013) | HP-UX (Itanium i64) (64 - Bit) | (11i) |
| v1.1 (Access 2000 - 2013) | Solaris (x86) (32 - Bit) | (2.8-2.11) |
| v1.1 (Access 2000 - 2013) | Solaris (x86) (64 - Bit) | (2.8-2.11) |
| v1.0 (Access 2000 - 2007) | HP-UX (PA-Risc) (32 - Bit) | (10.10-11) |
| v1.0 (Access 2000 - 2007) | HP-UX (PA-Risc 2) (64 - Bit) | (11) |
If the Access ODBC driver is not available for your platform, we have an alternative Access solution, which is available for additional UNIX platforms.
