Microsoft Access JDBC Driver and URL Information


Listed below are connection examples for Microsoft Access:


DRIVER CLASS: sun.jdbc.odbc.JdbcOdbcDriver

JDBC URL FORMAT: jdbc:odbc:<database_name>

To use the ODBC driver, an ODBC data source must be set up on your machine. Usually this can be done on Windows machines through the ODBC Data Source Administrator control panel. The database name in the JDBC URL is the name of the ODBC data source that you set up through the control panel.

Examples:

jdbc:odbc:test