Hi Barry,
Sorry for the dead link; my original post is attached here:
In order to access a MS Access data source, you need to register your database with the ODBC Data Source Administrator, see http://msdn2.microsoft.com/en-us/library/ms188691.aspx for details. During the configuration of your MS Access data source, you will be asked to define a Data Source Name. This unique ID is then used within KNIME's Database Reader dialog to access the MS Access database. Select the standard JDBC-ODBC driver and enter the URL to your registered the database as jdbc:odbc:YOUR_ID, enter user name and password, if specified, and edit the SQL statement as a last step.
Alternatively, you can use the following syntax to access the MS Access database directly: jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\\Database.accdb
Regards, Thomas