run: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid connection string attribute
<p>Below is the sample code that I have and it works fine, but with <em>Windows 7 home premium 64bit</em> on my laptop it doesn't. I get the following error: </p>

<pre><code>run:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid connection string attribute
</code></pre>

<p>I am using <em>NetBeans</em>.</p>

<pre><code>package javaapplication1;

import static java.lang.System.*;
import java.sql.*;

public class DBDemo1
{
    public static void main(String[] args)
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String sourceURL = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}DBQ=UserDB.mdb;";
            Connection userDB = DriverManager.getConnection(sourceURL, "admin", "");
            Statement myStatement = userDB.createStatement();
            String writeString = "INSERT INTO Users(Firstname, Surname, Id) VALUES('Fred', 'Bloggs', 'bf01')";
            myStatement.executeUpdate(writeString);

            ResultSet results = myStatement.executeQuery("SELECT Firstname, Surname, Id FROM Users ORDER BY Id");

            while (results.next())
            {
                out.print(results.getString(1) + " ");
                out.print(results.getString(2) + " ");
                out.println(results.getString(3));
            }
            results.close();
        }
        //The following exceptions MUST be caught
        catch(ClassNotFoundException cnfe)
        {
            out.println(cnfe);
        }
        catch(SQLException sqle)
        {
            out.println(sqle);
        }
    }
}
</code></pre>

<p>Any help is appreciated.</p>
