Trouble Trapping SQL Server login errors - 02-11-2005 , 07:12 AM
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).