How to open an MS Access file
![Taylor](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar8.png)
Taylor
Registered Posts: 15 ✭✭✭✭
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.
Answers
-
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-type/m-p/7880/highlight/true#M4184
-
CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
A new Knowledge Base article has been published on this topic: Utilizing MS Access in Dataiku DSS