Prev: Access and Outlook Automation
Next: Virtual checkboxes
From: Albert S. on 4 Jun 2010 17:32
Hello,

Are you using a connect string in Access? If so, what is it. Also are you
using TCP/IP (under Client configuration)?

Albert

"mcolson" <mcolson1590(a)gmail.com> wrote in message
news:cb71b45d-82f7-43d9-a5b8-0b5c907ad8f6(a)e2g2000yqn.googlegroups.com...
>I am getting the following error when trying to open a linked to sql
> table in access.
>
> Connection Failed
> sqlstate 28000 sql
> server error 18456
>
> Login failed for user(Windows Authentication ID)
>
> I set up the ODBC to use "SQL server authentication using a login ID
> and password entered by user". I checked "Connect to SQL Server to
> obtain default settings for the additional configuration options". I
> then used a login ID that exists in SQL. When I test the connection
> it works. But when I call it from Access, it reverts back to using
> the user's Windows Authentication. After clicking OK, a message box
> appears for connecting to sql. It shows the user ID set up in ODBC
> with no password. If I uncheck the box and enter the password, it
> then works... I'm stumped.


 | 
Pages: 1
Prev: Access and Outlook Automation
Next: Virtual checkboxes