Relative path to Access database

Hi everyone,

I'm currently trying to set up a database connector node connecting to an MS Access database.

I managed to install the ucanaccess driver and the connector works fine using an absolute path in the Database URL (like jdbc:ucanaccess://P:/folder/database.accdb). I just can't figure out how to transform this into a relative path.

I tried this: jdbc:ucanaccess://knime://knime.mountpoint/folder/database.accdb, but it causes an error ("Could not create connection to database: given file does not exist"). My guess would be that I am misunderstanding the way the Database URL works.

I would appreciate any help with this.



I did not yet find a solution for this, so my workaround at the moment is to export my Access database into single Excel tables and use relative links for those.

Hi MadF,

Is there any reason why do you want to use the relative path?

If you want to know more about how to connect to Access DB please take a look at the following post:

Hope that helps,




please have a look at the following post which contains an example workflow that uses a relative path to access a MS Access DB file which is located within the workflow directory: