Join us on July 16th as we explore real-world Reinforcement Learning Learn more

How to open an MS Access file

Level 2
How to open an MS Access file

I know it's been a while since this was asked, but is there a way to set up a connection like this if the .accdb file exists in a DSS managed folder?
/apps/DATA_DIR/managed_folders/<project_key>/<folder_object_id>/<databasename.accdb>
That is what I just tried but I'm getting an IO error message that says this is actually a directory.

0 Kudos
2 Replies
Level 2

For me it works from a DSS managed folder. Are you sure your path is correct?

Also check for the JDBC driver version, not sure what else doesn't work inside dataiku: https://community.dataiku.com/t5/Using-Dataiku-DSS/Connect-to-MS-Access-file-with-Date-Time-data-typ...

0 Kudos
Community Manager
Community Manager

A new Knowledge Base article has been published on this topic: Utilizing MS Access in Dataiku DSS

Don't forget to mark as "Accepted Solution" when someone provides the correct answer to your question.
0 Kudos