Fix Access ODBC Drivers That Show MDB but Not ACCDB Files in Java and NetBeans
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.

- 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 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.
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.
In NetBeans, expand the Services window, right-click Databases, and select New Connection to open the database driver setup.
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.
Use a JDBC URL in the format jdbc:ucanaccess://C:/databases/test.accdb and verify the path uses forward slashes, not backward slashes.
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.

Verify ACCDB File Location, Permissions, and Database Integrity
Use this when the file is not visible even after the file filter is changed, or the connection fails after selecting the file.
Report the File-Selection Limitation to UCanAccess Developers
Use this if both MDB and ACCDB formats are supported but the user interface still does not expose ACCDB files after local checks.
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. Download WPS Office: Go to the official WPS website and download the free installer for your Windows or macOS device.
- 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. 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.

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.




