getting 3146 ODBC - call failed error

running an ms access 2002 in ms access 2007.   large volume of records.  sql database.   55% complete then an error 3146
Doc1.doc
Startrac98Asked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
1. Since you did not post the details of how this is being done, it is difficult to tell.

2. Can you clearly quantify what you are calling a  "large volume of records"?

It might be just a network timing issue.
...or a function of the number of times the networks "Tries" to reach the destination.

In Access you can play around with the Client settings, and see if that helps:
untitled.JPG
0
 
danishaniCommented:
0
 
Startrac98Author Commented:
extended the timeout and the completion was successful.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Grrrreat!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.