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