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).
Any ideas?
Thanks,
chris |