Trouble Trapping SQL Server login errors

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