MS Access Can't Link to Encrypted Backend Database Tables

[oddstan]

Hello, does anyone know a solution?
Thanks.

I've got two DBs front-end and backend (access 2016), backend is encrypted.
when i'm trying to open linked to front-end backend tables, I would get a message box stating "Not a valid password."

I've tried couple solutions I've found on the internet (simple passwords, and DB Compact and repair), but neither had worked.

 

[isladogs]

Do you mean the BE is password protected or that its on an encrypted drive?

If its password protected you just need to include the password in the connection string

         If Nz(strLinkPassword, "") <> "" Then
               strConnectionString = "MS Access;" & _
                                    "PWD=" & Nz(strLinkPassword, "") & ";" & _
                                    "DATABASE=" & Nz(strLinkServer, "") & Nz(strLinkDatabase, "")
            Else
                strConnectionString = "MS Access;" & _
                                    "DATABASE=" & Nz(strLinkServer, "") & Nz(strLinkDatabase, "")
            End If