Constant ODBC Call Fails

[Charles]

Ok, I have an Access 97 GUI with SQL 7.0 backend. On one database I'm
constantly getting a call fail. I'm not sure why. From the user
accounts it seems to happen mostly when they have the form open, but
are static...doing something else. They begin to enter a record and
when they go to move to another record or save they get the error, but
not everytime. When the error occurs, they have to close out of the
database and open it back up.
I have mdac 2.8 on all the comps, and it's not just one user, but not
everyone gets the error. I get the errors on NT 4.0 and on win 2k. I
have a copy of the same database (only converted to AccessXP) with the
same SQL backend but have yet to get any errors on that copy.

Any ideas?

-charles

[Trevor Best]

Charles wrote:

Ok, I have an Access 97 GUI with SQL 7.0 backend. On one database I'm
constantly getting a call fail. I'm not sure why. From the user
accounts it seems to happen mostly when they have the form open, but
are static...doing something else. They begin to enter a record and
when they go to move to another record or save they get the error, but
not everytime. When the error occurs, they have to close out of the
database and open it back up.
I have mdac 2.8 on all the comps, and it's not just one user, but not
everyone gets the error. I get the errors on NT 4.0 and on win 2k. I
have a copy of the same database (only converted to AccessXP) with the
same SQL backend but have yet to get any errors on that copy.

Any ideas?

-charles

This may help track it.

(air code from memory)
Sub Form_Error(Errn um as integer, Response as integer)
Dim e as Error, strMsg As String
If ErrNum = 3146 Then ' < (Check this is ODBC call failed number)
strMsg = "ODB Errors"
For each e in DbEngine.Errors
strMsg=strMsg & vbCrLf & e.number & " - " & e.Description
Next
MsgBox strMsg, vbCritical
Response = DataErrContinue ' < (Check this constant)
Else
Debug.Print "Error: " & e.number & " - " & e.Description
End if
End Sub

--
Error reading sig - A)bort R)etry I)nfluence with large hammer