Relative path to Access database

KNIME Analytics Platform
1

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.

 

Update:

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.

2

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: https://tech.knime.org/forum/knime-general/no-connection-to-ms-access-database

Hope that helps,

Best,

Vincenzo

3

Hi,

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:

https://www.knime.com/forum/knime-general/how-to-connect-to-ms-access-database

Bye

Tobias