Microsoft Access on Windows Systems

Use the Database Test utility from the Utility menu to test and debug your database connection settings.

Step 1. Install Driver
Microsoft Access users do not need to install any extra drivers on their system.  Automize uses Java 1.3 which comes preinstalled with the necessary JDBC:ODBC bridge driver to connect to Access.

Step 2. Configure your system ODBC DSN

Step 3. Driver Class Name
For convenience, Automize will understand the following class name:
access
The actual classname is longer:
sun.jdbc.odbc.JdbcOdbcDriver

Step 4. Database Url
The format of the Url is:
jdbc:odbc:DSN
where DSN is the Data Source Name that you entered in step 2.  Do not confuse DSN with your actual database name or the path to your database.

Step 5. Test the Connection
Hit the Test the Connection button.  If everything was setup correctly, you will see some database information.