Ingration NAV 2009 R2 with MS Access DB with Password

smc

Hi

I am trying to ingrate Navision 2009 R2 with MS Access DB with Password .

Using ODBC connection string

While i am connecting the Access from the Application server, i am able to access the same. If I am trying the same the Client Machine i am getting the following error

Can you any body help on this.

---

Microsoft Dynamics NAV

---

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.



Page Edit - Receipt - WRCPT00019 must close.

---

OK

---

BardurKnudsen

Just one tip: Most likely the NAV Server and the client run under different credentials / user id, so maybe you have an issue with permissions to the file location itself from the client machine / user.

smc

I am trying with same user only, still that is not working.