Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ashipp2010
Contributor
Contributor

Create Access Data Connection

Good Morning,

Ihave a remote share that has an access database on it in the accdb format. I am trying to create a data connection to that access DB. 

 I installed the most recent ODCB drivers for Access, but when I try to add the file via ODBC it fails because it requires setting the file path via mapped drive, which isn't supported. Is there a way to set it directly to the share without mapping the drive? ie. \\servername\filename.accdb?

I also tried to add via Ole DB, but the connection failed. When I click test connection it throws the generic error "Connection failed".

Thanks for any feedback!

Labels (1)
1 Reply
Anil_Babu_Samineni

I may think this way, Create ODBC Driver for that for all nodes and use that driver to connect DB while creating connection in the script.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)