JDBC URL for direct Connection to an Access database

If you want to connect to an Access Database File (*.mdb file) without creating an DSN entry in the system, you can enter all needed informations directly in the JDBC URL. Here is an example for the German Access driver

jdbc:odbc:Driver={Microsoft Access-Treiber (*.mdb)};dbq=D:\temp\example.mdb;uid=Admin

Replace the driver name you usually use in the DSN configuration and the concrete path to the mdb file and you should be able to access to the access file via JDBC.

Hope this hint helps.

Comments are welcome.