I'm using MS Access as a front end

[dmaranan]

I'm using MS Access as a front end for SQL Server 2000. I've created a login form that authenticates against SQL Server permissions (created a connection string). When a user enters the wrong username and password I get this error message:

Connection failed:
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Drive]Invalid connection string attribute
Connection failed:
SQLState: '28000'
SQLServer Error: 18456
[Microsoft][ODBC SQL SErver Drive][SQL Server]Login failed for user 'userusge'

Beause this error message doesn't make sense to most users, I would like to create my own error message saying, "Please re-enter your username and password."

Can anyone help?

 

[mkrausnick]

You should probably post this question in the ACCESS forum. It seems like you need some ACCESS code to trap the error when it happens and do your own routine.

Mike Krausnick
Dublin, California