Create Access Data Connection

[ashipp2010]

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!

[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.