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.

You need to ensure you have a login on the sql server and that you have been registered as a user on the db you are trying to connect to.