By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

"Connection Failure"

P: n/a
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 currentconnection before calling the the execute
statement and users are using Access built-in login to the SQL Server
backend using Windows NT authentication.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
lauren quantrell wrote:
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 currentconnection before calling the the execute
statement and users are using Access built-in login to the SQL Server
backend using Windows NT authentication.


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]
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.