ODBC Driver for Microsoft Access
ODBC Driver for Microsoft Access icon

ODBC Driver for Microsoft Access

by Devart
$139.95
Version
2.2.0
License
Shareware
Trial Limitations
30-day free trial, evaluation use only. Download needs a free Devart account
Operating Systems
Windows Vista and later (32/64-bit, Windows Server, Terminal Server), macOS x64 and ARM, Linux x86 and x64
System Requirements
Windows Vista or later, 32-bit or 64-bit (incl. Terminal Server), .NET Framework 4.5. Also macOS (x64, Apple silicon, iODBC) and Linux x86/x64 (unixODBC). No Access, Office or ACE needed
File Size
33.21 MB
Release Date
10/16/2026
Last Updated
11/15/2026
8 views 0 downloads
Reads and writes Access .mdb/.accdb files on Windows, Mac and Linux via ODBC

Devart ODBC Driver for Microsoft Access: Open .mdb and .accdb Files Anywhere, Without Office

Devart ODBC Driver for Microsoft Access is a standalone ODBC driver, from $139.95 a year, that reads and writes Access database files (.mdb and .accdb, up to Access 2021) on Windows, macOS and Linux. It needs neither Access, Office nor Microsoft's Access Database Engine, so Power BI, SQL Server, Python or a Linux ETL job can use an Access database directly.

Plenty of companies still run on an Access file someone built fifteen years ago. Getting at its data from other software usually means Microsoft's ACE driver, which is Windows-only and tied to the bitness of the installed Office. Devart's driver exists to get around exactly that.

Quick facts

  • Version: 2.2.0, released October 16, 2026; first released April 10, 2024
  • Developer: Devart
  • Database formats: .mdb and .accdb up to Access 2021, including the Access 97 (Jet 3) format
  • Platforms: Windows Vista or newer (32-bit and 64-bit, Terminal Server too, .NET Framework 4.5), macOS on Intel and Apple silicon, Linux x86 and x64
  • Dependencies: none; no Access, Office or ACE/Jet engine required
  • Price: $139.95 a year or $279.95 perpetual for one desktop user
  • Trial: 30 days, for evaluation only, downloaded with a free Devart account
  • Refund: full refund within 30 days only when a technical problem stops the driver working and Devart's support can't solve it
  • What we checked: the order page charged $139.95 for Desktop for Windows with one year of updates on a yearly subscription (renewing at the same price), and the download page listed version 2.2.0 with a 33.21 MB Windows installer, on November 15, 2026. We didn't open an Access database with it

Download Free Trial Buy Now

Overview

The driver works on the database file itself. You give it the full path to an .mdb or .accdb file and it exposes the tables, columns, indexes and primary keys through standard ODBC calls. Saved Select and Union queries in the Access file appear as views, so the logic someone built into the database years ago can be reused rather than rewritten.

Data types map both ways, from Short Text and Long Text to Currency, Yes/No, Date/Time Extended and OLE Object, and AutoNumber columns, including the Replication ID kind, are handled. Devart documents connections from Excel, Power BI, Tableau, QlikView, SQL Server Management Studio, SSIS, Oracle database links, DBeaver, Informatica, OpenOffice, Visual Studio, PHP and Python.

Features

No Access Database Engine to install

Devart ODBC Driver for Microsoft Access is self-contained, so there's no ACE redistributable to install and no clash with the Office version on the machine. Its 32-bit and 64-bit drivers can be installed side by side, which Microsoft's driver doesn't allow when Office is present.

Access files on a Mac or a Linux server

Devart ODBC Driver for Microsoft Access runs on macOS (Intel and Apple silicon) and Linux, where no Microsoft Access driver exists at all. A Python script on a Linux server can read an .accdb file copied from a Windows share, and Excel for Mac can query one too, as long as the file sits in Excel's sandbox folder.

Several applications on one database

Devart ODBC Driver for Microsoft Access 2.1 added Shared Mode, which lets several applications read and write the same database at once, coordinating them with file locks; a conflicting operation waits up to the Shared Timeout (5 seconds by default) before returning an error. Shared Mode is Windows-only. Elsewhere, Read Only allows multiple readers and Exclusive Lock keeps one user in sole control.

Faster reads and bulk changes

Devart ODBC Driver for Microsoft Access 2.0 sped up INSERT, UPDATE and DELETE inside a transaction and added CacheSize and CacheLifetime for caching in Exclusive Lock mode and PartialIndex for faster SELECTs. Batch updates, connection pooling and prepared statements are supported.

Old databases with old encodings

Devart ODBC Driver for Microsoft Access has a Character Set setting for older formats such as Access 97, which store text without Unicode, so accented or Cyrillic text from a legacy file comes out readable. Version 2.2 improved Access 97 (Jet 3) support.

Benefits

  • Retire the Office dependency. Servers that read an Access file no longer need Office or the ACE engine installed and kept in step.
  • An easier way off Access. SQL Server, PostgreSQL or a Python script can pull every table out with SQL when you move to a real database server.
  • Legacy logic stays usable. Saved queries show up as views instead of being rebuilt.
  • Mac and Linux teams join in. Analysts off Windows can finally open the company's .accdb files.

Real-World Uses

  • Migration to SQL Server. A DBA links the Access file into SQL Server Management Studio as a linked server and copies table after table with INSERT ... SELECT.
  • Reporting on a front-office app. A small firm's Access order database feeds a Power BI dashboard without exporting to Excel each week.
  • Linux ETL. A nightly Python job in a Linux container reads a vendor's .mdb delivery and loads it into PostgreSQL.
  • Two programs, one file. A Windows service writes readings into an Access database while a desktop app reads them, using Shared Mode.

Who It's For, and Who Should Skip It

The Access driver suits developers and administrators who inherit Access databases and need them inside modern tools, servers that must read .mdb or .accdb files without Office, people moving data off Access, and Mac or Linux users with no other way in.

Skip it if everything happens on Windows PCs that already have a matching Office and Microsoft's free Access driver works for you, or if you only open the database in Access itself. For a database many people write to all day, move to a database server rather than relying on file locking.

Usage Guide

  1. Sign in to your free Devart account and download the EXE or MSI (Windows), PKG (macOS) or RPM/DEB package (Linux).
  2. Install it, and activate with your key or keep the 30-day trial.
  3. Create a DSN: on Windows open ODBC Data Sources (32-bit or 64-bit), Add, choose Devart ODBC Driver for Microsoft Access and enter the database path; on macOS or Linux use the graphical setup tool added in 2.0.
  4. Choose the access mode in Advanced Settings: Read Only, Exclusive Lock or Shared Mode, and a Character Set for old files.
  5. Connect from your tool, or use a connection string such as DRIVER=Devart ODBC Driver for Microsoft Access;Database=D:\Data\orders.accdb.

Before you buy

The connection settings have the database path and no password field. If your .accdb has a database password or encryption, open it with the trial before you buy. Also note that a split Access application keeps its data in a back-end file: point the driver at that file, not the front end.

Where it falls short

  • Shared Mode is Windows-only. On macOS and Linux, concurrent use is limited to read-only.
  • Exclusive Lock and Shared Mode can't be combined. You choose one or the other per connection.
  • Forms, reports and macros aren't data. Only tables and Select/Union queries come through; action queries and VBA stay in Access.
  • Bug fixes are recent. 2.0 fixed wrong results for WHERE clauses with "<" and a crash with LIKE, and 2.1 fixed a "BCD overflow" on Decimal fields, so check your own queries during the trial.
  • macOS sandboxing. Excel for Mac can only open database files in its own container folder.

What Users Say

No reviews of the Access driver alone have been published; Devart's ODBC drivers are reviewed as a family.

Ratings for the Devart ODBC line

Devart ODBC Drivers hold 4.7 out of 5 on Capterra (26 reviews) and 4.6 out of 5 on G2 (18 reviews). Most reviewers used the database or Salesforce drivers and point to straightforward setup, stable connections and fair pricing; their complaints are mainly the cost when several drivers are needed and SQL being hard going for beginners.

Comparisons

Devart vs. Microsoft's Access (ACE) ODBC driver

Microsoft's driver is free but runs only on Windows, needs the Access Database Engine, and allows one bitness per machine, matching the installed Office. Devart's own comparison lists its driver as standalone, cross-platform, 32-bit and 64-bit side by side, and unaffected by Office updates. If you're on Windows and the free driver already works, keep it; pay for Devart's when Office conflicts, Mac, Linux or servers get in the way.

The Access driver alone vs. the ODBC Universal Bundle

The Universal Bundle covers all 92 Devart ODBC drivers, Access included, from $499.95 a year for a desktop. It makes sense if the Access migration also needs, say, SQL Server, PostgreSQL and Excel drivers; for Access alone, the single driver at $139.95 is the cheaper buy.

Editions and Pricing

Edition1-year subscriptionPerpetualWho can use it
Desktop (Windows, macOS or Linux)$139.95$279.95One person on one computer
Server Standard (Windows, macOS or Linux)$899.95$1,799.95Multiple users on one server of up to 6 cores, one company
Server Enterprise, Site, OEMQuoteQuoteUnlimited cores, unlimited company computers, or redistribution in your own software

Buy Now starts an order for Desktop for Windows with a 1-year subscription; you switch edition, operating system, term (1, 2 or 3 years) or license type on the order page. A server that a web app or several users reach needs a Server edition even if only one person administers it.

FAQs

Can I open an Access database on a Mac with the Devart driver?

Yes. Devart ODBC Driver for Microsoft Access has a macOS edition for Intel and Apple silicon Macs, used through the iODBC driver manager; with Excel for Mac, the database file has to be in Excel's container folder because of sandboxing.

Does the Devart Access driver work with Access 2000 or Access 97 files?

Yes. Devart ODBC Driver for Microsoft Access reads .mdb files including the Access 97 (Jet 3) format, improved in version 2.2, and its Character Set option handles their non-Unicode text.

Will installing it conflict with Microsoft Office?

No. Devart ODBC Driver for Microsoft Access doesn't use the Office or ACE components, so 32-bit Office on the same PC doesn't stop you installing the 64-bit driver, and Office updates don't change how it behaves.

What happens when my subscription ends?

Devart ODBC Driver for Microsoft Access on a subscription stops working when the term ends and needs internet access to check its license. A perpetual license keeps working, and its updates can be renewed; Devart's ordering FAQ says the renewal costs 20% more after a three-month gap and 60% more after twelve months.

Is there a money-back guarantee on the Access ODBC driver?

Only for technical failures. Devart refunds Devart ODBC Driver for Microsoft Access in full within 30 days of purchase when a problem or bug stops it working and support can't fix it; a change of mind doesn't qualify, which is what the 30-day trial is for.

Can a web application on a server use the Desktop license?

No. Devart ODBC Driver for Microsoft Access Desktop covers one user on one computer; a web or application server that several users reach needs Server Standard (up to 6 cores) or Server Enterprise.

System Requirements

  • Windows Vista or newer, 32-bit or 64-bit, desktop, server or Terminal Server, with .NET Framework 4.5 or later
  • macOS x64 or Apple silicon with iODBC
  • Linux x86 or x64 with unixODBC
  • 33.21 MB Windows installer, one version of the driver at a time
  • File access to the .mdb or .accdb database

Conclusion

Devart ODBC Driver for Microsoft Access earns its $139.95 a year when Microsoft's free driver is the problem: Office bitness conflicts, servers without Office, or Macs and Linux machines that can't read Access files at all. It's also a tidy tool for getting data out of Access for good. The main reason not to buy is that on an ordinary Windows PC with matching Office, Microsoft's driver does the basic job for free. Try your own database, especially a protected or very old one, in the trial first.

Download Free Trial Buy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.