HXTT Access: Read and Write Microsoft Access Databases from Java on Any Platform
HXTT Access is a pure Java (type 4) JDBC driver with a built-in database engine that lets Java applications read and write Microsoft Access databases (MDB and ACCDB, Access 95 through 2016) with standard SQL, with no Access, Jet, ACE or ODBC driver installed. It's for Java developers and DBAs who need Access data on servers, especially Linux or macOS. A Single Server License costs $395, one-time.
Access files turn up everywhere: departmental apps, data exports from instruments and vendors, years of records in an .accdb on a shared drive. Microsoft's drivers only run on Windows, and Java's old JDBC-ODBC route is gone. HXTT Access opens the files directly from Java, wherever the JVM runs, and can share them with Access users through Access-compatible locking.
Quick facts
- Version: 7.1.277, built July 13, 2026
- Developer: Heng Xing Tian Tai Lab of Xi'an City (HXTT)
- Platform: any operating system with a Java VM; JDBC 1.2, 2.0, 3.0, 4.0, 4.1, 4.2 and 4.3 packages
- Formats: Microsoft Access 95, 97, 2000, XP, 2002, 2003, 2007, 2010, 2013 and 2016 databases (MDB and ACCDB)
- Price: $395 Single Server, $1,767 100 User Application, $2,536 Enterprise; perpetual, with one year of free upgrades and email support
- Trial: free 30-day evaluation package; it runs at most 50 queries per session and returns only the first 1,000 rows of a SELECT
- Refunds: requested through 2Checkout within 30 days of the order
- What we checked: the evaluation download access.zip (3.1 MB), whose Access_JDBC30.jar reports version 7.1.277 of July 13, 2026; order page prices of $395, $1,767 and $2,536 for the three licenses, all lifetime, on November 22, 2026. We didn't connect it to an Access database.
Download Free TrialBuy Single Server LicenseBuy 100 User Application LicenseBuy Enterprise License
Overview
HXTT Access is a JDBC driver and a database engine in one jar. Add it to your classpath, load com.hxtt.sql.access.AccessDriver and connect with a URL such as jdbc:access:/path/to/data; tables, and Access queries as views, become available to SQL. Because it's standard JDBC, Hibernate, Tomcat, Crystal Reports, DbVisualizer, SQuirreL SQL and other Java tools can use it.
The engine runs embedded in your application or as a server that other machines reach in client/server mode. Every package also includes DBAdmin, a small Java GUI for starting, stopping and monitoring HXTT servers and running SQL, which can run as a Windows service, a Unix or Linux daemon, or a standalone program.
Features
Access objects, not just tables
HXTT Access supports Access queries as views, linked tables to other Access databases, simple stored procedures (select, insert, update and delete), and joins across more than one MDB or ACCDB file in a single query. With lockType=ACCESS it uses Access-compatible locking, so Java code can work alongside people using Access itself.
Full transactions and modern SQL
HXTT Access supports all four JDBC transaction isolation levels and nearly full ANSI SQL-92 plus many SQL:2008 additions: all join types, UNION, INTERSECT and EXCEPT, every kind of subquery, common table expressions, GROUP_CONCAT, WITH ROLLUP and WITH CUBE, PIVOT and UNPIVOT, OFFSET and FETCH, COPY DATABASE and CLONE DATABASE, and more than 230 SQL functions.
Databases wherever they are
HXTT Access opens databases from local folders, mapped drives and UNC paths, SMB shares (including Azure file shares), HTTP, HTTPS, FTP, FTPS and SFTP URLs, from inside ZIP, JAR, GZ, BZ2, 7z and TAR archives, from a Java InputStream, or as memory-only tables.
Connections and security
HXTT Access handles concurrent, thread-safe connections with connection pooling, DataSource, distributed transactions and RowSet, and offers user and password checks, SSL connections, and DES, Triple DES, Blowfish and AES encryption at the SQL or database level.
Benefits
- No Windows dependency. Java code reads Access data on Linux and macOS servers with no Microsoft drivers.
- No conversion needed to put a web or reporting front end on an Access database.
- One jar to deploy, with no native libraries or ODBC setup.
- A perpetual license with a year of upgrades and support included.
Real-World Uses
- A Linux web application reads a department's Access database from a Windows share and shows its records on an intranet.
- Data import: a Java ETL job pulls vendor-supplied .accdb files from an SFTP server and loads them into a central database.
- Migration: a developer copies an old Access application's tables into PostgreSQL with plain JDBC.
- Reporting: a Java reporting server queries several Access files at once with joins across them.
Who It's For, and Who Should Skip It
HXTT Access is for Java developers, integrators and DBAs who need reliable read and write access to Access databases from Java, particularly on servers that aren't Windows or where Microsoft's drivers can't be installed.
Skip it if you don't program in Java: it's a library, not a way to open Access files by hand. Java developers on a tight budget should try the free open-source UCanAccess driver first. And .NET or ODBC applications on Windows can use Microsoft's own Access drivers.
Usage Guide
- Download the evaluation package (access.zip) and unzip it. It contains the JDBC 3.0 jar, documentation and demo programs; other JDBC packages are available after registering on HXTT's site.
- Add Access_JDBC30.jar to your classpath or your application server's library folder.
- Connect with
jdbc:access:/path/to/data in embedded mode, or to a remote HXTT server; add lockType=ACCESS if Access users share the file.
- Query with SQL and try the demo programs in the package.
- Run DBAdmin from the same jar if you want a managed server.
- Buy a license for your deployment before the evaluation period ends.
Where it falls short
- Access versions listed to 2016. HXTT names the Access 95 through 2016 formats; test files saved by newer Access versions with the trial.
- No forms, reports or VBA. It works with data, queries and simple stored procedures, not the Access application layer.
- The trial is tightly limited. The evaluation jar runs at most 50 queries per session and returns only the first 1,000 rows of a SELECT, and after 30 days it throws "No suitable driver" and "Evaluation period over".
- Business pricing. $395 per server is fine for a company system but steep for a small personal project, and shipping it inside your own product needs the 100 User Application License.
- Updates are included for one year; after that, support and upgrades are a yearly renewal.
- Terse documentation and an old-style admin GUI.
Comparisons
HXTT Access vs UCanAccess
UCanAccess is a free, open-source JDBC driver for Access built on the Jackcess library and is the usual first choice for Java developers. HXTT Access is commercial, with its own engine, and adds a client/server mode, Access-compatible locking, remote, compressed and in-memory databases, joins across several Access files, and paid support. If UCanAccess handles your files and workload, it's hard to beat on price; HXTT Access is for cases that need its extra modes or vendor support.
HXTT Access vs Microsoft's ODBC drivers
Microsoft's Access drivers are Windows-only, and Java's JDBC-ODBC bridge was removed in Java 8. HXTT Access is pure Java, so it runs on Linux and macOS as well.
Editions and Pricing
| License | Price | What it covers | Buy |
| Single Server License | $395 | Unlimited connections on a single server | Buy Single Server |
| 100 User Application License | $1,767 | Unlimited connections; redistribute 100 times with one commercial product | Buy 100 User |
| Enterprise License | $2,536 | Unlimited connections and servers, within one company in one country | Buy Enterprise |
Every license includes one year of free online upgrades and technical support by email and forum. HXTT quotes bulk discounts on request.
FAQs
Does HXTT Access read both .mdb and .accdb files?
Yes. HXTT Access supports Access databases from Access 95 through 2016, which covers both the older MDB format and the ACCDB format introduced with Access 2007.
Can HXTT Access run on Linux without Microsoft Access installed?
Yes. HXTT Access is written entirely in Java with its own database engine, so it needs only a Java VM and no Microsoft software.
Can HXTT Access run saved Access queries?
HXTT Access exposes Access queries as views and supports simple stored procedures (select, insert, update and delete), as well as linked tables to other Access databases.
Which license do I need to ship HXTT Access with my product?
To redistribute HXTT Access with a commercial product, the 100 User Application License covers 100 copies of one product. The Single Server and Enterprise licenses are for running it on your own servers.
How do I get a refund?
Online orders for HXTT Access are handled by 2Checkout, which accepts refund requests up to 30 days from the order date.
System Requirements
- Any operating system with a Java VM: Windows, Linux, macOS, Unix, Solaris, AIX, FreeBSD and others
- Java from Personal Java and JDK 1.0 through current versions, with the matching JDBC 1.2 to 4.3 package
Conclusion
HXTT Access is worth $395 for a single server if you need dependable Java access to Access databases on any platform, with extras such as client/server mode, Access-compatible locking, cross-database joins and vendor support, in a build from July 2026. The reason to hesitate is price: the free UCanAccess covers many simpler needs. Try your own MDB or ACCDB files with the 30-day evaluation before buying.
Download Free TrialBuy Single Server LicenseBuy 100 User Application LicenseBuy Enterprise License