I’m having this scenario, I have Microsoft Access Raw Data set File Present in Folder I want to connect this database file and read the table present inside it, the issue is that I’m connecting to the dataset file but I’m unable to get the files from the data set below is my architecture.
Microsoft Raw Access File (Database File) Location
DBCPConnectionPool For Microsoft Access
Database Connection URL : jdbc:ucanaccess://C:/Users/a_hkadumbaga/Downloads/Datasets/Access DataBase File.mdb;memory=false
Database Driver Class Name : net.ucanaccess.jdbc.UcanaccessDriver
Database Driver Location(s) : C:Usersa_hkadumbagaDocumentsSoftware DevelopmentSAASUcanAccess Files
Access DataBase Connection Enabled
QueryDatabaseTableRecord Processor
Fetching Records Processor Architecture
Ucan Access Files Location
Any suggestions will be much appreciated to enable me read the data from this Access data set file.