access 2007 network providor problem
Dears
i am trying to connect VB6 to access database 2007 that exist in server , the problem is that the server has admin and password that i should assign them in the providor .
i tried that but it said (Not a valid account name or password) .
thanks for help
Re: access 2007 network providor problem
i forgot to mention the providor syntax that i used :
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\212.123.45.122\HR\s.accdb;User Id='HR\AdminHR';Password='P@ss123';"