Download the Access JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.
A JDBC driver is a Java .jar library that lets applications connect to Access.
DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation.
Driver files are usually published by the database vendor or an open-source project.
Host, port, database name, and SSL options are passed in a URL starting with jdbc:.
Each Access driver uses its own syntax — see the connection details below.
Microsoft Access is a desktop relational database management system included in Microsoft Office, widely used for small business databases, data entry forms, and local data management. The UCanAccess JDBC driver provides read/write access to .mdb and .accdb files from Java applications.
The driver archive is a zip file. Extract it and load all the .jar files using DbSchema's Driver Manager. The JDBC source code is located on http://ucanaccess.sourceforge.net/
DbSchema connects to Access .mdb and .accdb files using the UCanAccess driver, rendering tables, relationships, and queries as a visual schema diagram. This is especially useful for migrating Access databases to a server-based RDBMS like MySQL or PostgreSQL using DbSchema's Schema Synchronization.
Connect Access, build your first ER diagram in minutes. No account required.
Get the Access driver zip below and install DbSchema for Windows, macOS, or Linux.
In DbSchema, open Driver Manager, add the extracted JAR, and paste your JDBC URL.
Reverse engineer Access, edit the model visually, and publish schema documentation.
After the JDBC driver connects, you get ER diagrams, SQL editor, schema sync, and HTML documentation in one desktop app. Compare DbSchema editions.
Reverse engineer Access into an interactive diagram and edit structures visually.
Run SQL with autocomplete or compose queries without writing every join by hand.
Export HTML docs your team can browse without installing DbSchema.
Connection tips, ports, SSL, and schema design workflows on the database landing page.
Other drivers teams often configure alongside Access.
Teams working with Access often use these engines too. Explore dedicated guides and JDBC setup for each.