• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

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
0
Startrac98
Asked:
Startrac98
  • 2
1 Solution
 
danishaniCommented:
0
 
Jeffrey CoachmanCommented:
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
 
Startrac98Author Commented:
extended the timeout and the completion was successful.
0
 
Jeffrey CoachmanCommented:
Grrrreat!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now