Trouble Trapping SQL Server login errors

[chris.ciotti]

Hi all -

I'm trying to track down why Access (ACC2000) will not throw an error
when the user does not have a login on the SQL server (SQL Server
2000). In the Form_Load() event, I have the usual On Error GotTo
ErrCheck and in ErrCheck, I have only MsgBox Err.Number. It nevr comes
up as Err.Number == 0 yet the SQL Server has thrown an exception (Err #
18456).

Any ideas?

Thanks,

chris