How to open an MS Access file

Taylor
Level 3
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
rikro
Level 3

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
CoreyS
Community Manager
Community Manager

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

Looking for more resources to help you use DSS effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!
0 Kudos
A banner prompting to get Dataiku DSS
Public