"Connection Failure"

[lauren quantrell]

Admitedly a very open-ended question but here goes ...
Why so may "Connection failure" error messages when my Access 2K users
are executing stored procedures that contain UPDATE or INSERT
statements? I am using currentconnecti on before calling the the execute
statement and users are using Access built-in login to the SQL Server
backend using Windows NT authentication.

[Trevor Best]

Re: "Connectio n Failure"

lauren quantrell wrote:[color=blue]
> Admitedly a very open-ended question but here goes ...
> Why so may "Connection failure" error messages when my Access 2K users
> are executing stored procedures that contain UPDATE or INSERT
> statements? I am using currentconnecti on before calling the the execute
> statement and users are using Access built-in login to the SQL Server
> backend using Windows NT authentication.
>[/color]

A connection failure can occur when a serious error occurs, say level 20
or over, these are logged. Look in the SQL Server logs and/or the
server's application log.

--
[OO=00=OO]