Access 2003.
I've created my own Linked Table manager for use in several of my
applications. It is running fine when I use Windows authentication, or
when
I use a valid userid and password, but when I try to log in with an
invalid
userid/password, I get a Microsoft SQL Server Login error message which is
not handled by my error handler. The message looks like:
Connection failed:
SQLState:'01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memroy]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error:17
{Microsoft][ODBC SQL Server Driver][Shared Memory] SQL Server does not
exist
or access denied.
When I click OK, it pops ut a SQL Server Login dialog box. I want to
replace this process with my own error handling, but Access is not
trapping
the SQL Server error. Is there any way to get around this so I can ensure
that the user is entering the connection info into my application?
