On Tue, 2 Sep 2003 17:00:26 -0700, "bert" <bert_w@att.net> wrote:

>We are accessing SQL Server 2000 with a MS Access 97
>application using an ODBC connection.
> I have set up the ODBC driver and connected to the
>database using a SQL Server account. I have it set to use
>SQL Authentication using an ID and password entered by
>the user. I can connect and run queries for this account
>using Query Analyzer.
> When I try to connect using the MS Access application I
>receive the following error message:
>Connection Failed:
>SQLState: 28000
>SQL Server Error: 18452
>....Login failed for user '(null)'. Reason: Not
>associated with a trusted SQL Server connection.
>I click 'OK' on the button and then a window opens
>listing my ODBC data source, the Login ID and the 'Use
>Trusted Connection' box is selected. If I uncheck the box
>and enter a password I connect fine.
> How can I get the ODBC driver to present the login
>prompt without all of the error hoopla?
> Thank you, -bert