Others

Fix Access ODBC Drivers That Show MDB but Not ACCDB Files in Java and NetBeans

Steven ParkerSteven Parker Nov 13, 2026 869 views

Question details

The user needs to connect Java and NetBeans to Microsoft Access 2010 .accdb databases through UCanAccess, but the ODBC/driver interface only lists .mdb files.

Fix Access ODBC Drivers That Show MDB but Not ACCDB Files in Java and NetBeans
Product
Microsoft Access 2010 ODBC drivers, UCanAccess JDBC driver, NetBeans
Device & OS
Windows (32-bit and 64-bit)
Scenario
The user is setting up a Java database connection in NetBeans with UCanAccess and expects to select an Access .accdb file.
Observed behavior
The file picker or ODBC driver dialog shows .mdb files but does not display .accdb databases, even though UCanAccess documents support both formats.
Before you start

Before changing the connection, close any open NetBeans database sessions and note whether your Java/JDK installation is 32-bit or 64-bit; also copy the .accdb file to a simple local path such as C:\databases\test.accdb for testing.

Solution 1Recommended

Check the UCanAccess File Filter and JDBC URL for ACCDB Files

Use this first when the UCanAccess dialog or ODBC list is set to a narrow file type and the connection string points to the correct .accdb location.

UCanAccess supports both MDB and ACCDB databases, so a missing ACCDB file is usually a file-filter, URL, or architecture issue rather than an ODBC format limitation.

1
Open the UCanAccess connection settings

In NetBeans, expand the Services window, right-click Databases, and select New Connection to open the database driver setup.

2
Change the file type filter to .accdb or All Files

In the UCanAccess file selection window, set the Files of type drop-down to 'All Files' or '*.accdb' instead of the default '*.mdb' so Access 2010 .accdb databases become visible.

3
Enter the full JDBC URL manually

Use a JDBC URL in the format jdbc:ucanaccess://C:/databases/test.accdb and verify the path uses forward slashes, not backward slashes.

4
Match the JDK and driver architecture

In NetBeans, open Tools > Java Platforms and confirm whether the active JDK is 64-bit or 32-bit, then use the matching UCanAccess and Access ODBC driver architecture.

Check the UCanAccess File Filter and JDBC URL for ACCDB Files
If the file still does not appear: Add the UCanAccess, Jackcess, and HSQLDB dependencies to the project classpath, then restart NetBeans before retesting the connection.
Free Microsoft Office alternative

If Access ODBC Issues Stall Your Work, Use WPS Office as a Lightweight Office Alternative

WPS Office gives you a free, lightweight way to open, edit, and save Word, Excel, and PowerPoint documents without ODBC driver configuration. It keeps familiar menus and broad Microsoft Office format compatibility so switching from daily Microsoft Office tasks is straightforward.

  1. 1. Download WPS Office: Go to the official WPS website and download the free installer for your Windows or macOS device.
  2. 2. Open existing Office files: Launch WPS Office and open your existing Word, Excel, or PowerPoint files from the home screen or File > Open.
  3. 3. Edit and save in compatible formats: Use the familiar toolbar to edit the document, then save it as .docx, .xlsx, or .pptx to maintain Microsoft Office compatibility.
Opens and saves .docx, .xlsx, and .pptx files with high Microsoft Office format compatibilityFree, lightweight suite with Writer, Spreadsheet, Presentation, and PDF toolsFamiliar ribbon-like interface reduces the learning curve when migrating from Microsoft OfficeNo ODBC driver or Java setup required for everyday Word, Excel, and PowerPoint work
microsoft office alternative - wps office

Frequently Asked Questions

Does UCanAccess support Access 2010 .accdb files?

Yes. UCanAccess supports both .mdb and .accdb databases, including Access 2007, 2010, 2013, and 2016 file formats. If an .accdb file is missing, the issue is usually a file-type filter, connection string, architecture mismatch, or file permissions.

Why does the ODBC file dialog only show .mdb files?

Many Access ODBC and UCanAccess dialogs default to a narrow file-type filter or to *.mdb. Change Files of type to All Files or *.accdb, or type the full .accdb path into the connection string instead of using the file picker.

Do I need 32-bit and 64-bit Access ODBC drivers at the same time?

No. Use the architecture that matches the Java/JDK version running NetBeans. A 64-bit JDK requires 64-bit ODBC/UCanAccess components, while a 32-bit JDK requires 32-bit components.

Can WPS Office open .accdb database files?

WPS Office is a free Microsoft Office alternative for documents, spreadsheets, and presentations, not a Microsoft Access database replacement. It is designed for Word, Excel, PowerPoint, and PDF-compatible workflows, so .accdb databases still require Microsoft Access or UCanAccess.