Hello,
how can I connect an adp database with SQL server Express on a SQL server 2008.
For the moment I have a project (adp) database using access 2007.
I'm able to create an ODBC connection and I can access the remote server without any problem.
When I open in access the server connection, type in the ip adress, I get an error regarding the fact that the user isn't recognized.
I use the same user and password as the ODBC connection and doing so,
I still have the error. What is wrong here?
Thanks in advance,
Sven.
how can I connect an adp database with SQL server Express on a SQL server 2008.
For the moment I have a project (adp) database using access 2007.
I'm able to create an ODBC connection and I can access the remote server without any problem.
When I open in access the server connection, type in the ip adress, I get an error regarding the fact that the user isn't recognized.
I use the same user and password as the ODBC connection and doing so,
I still have the error. What is wrong here?
Thanks in advance,
Sven.