getting 3146 ODBC - call failed error

Posted on 2011-05-02
Last Modified: 2012-05-11
running an ms access 2002 in ms access 2007.   large volume of records.  sql database.   55% complete then an error 3146
Question by:Startrac98
    LVL 12

    Expert Comment

    LVL 74

    Accepted Solution

    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:

    Author Closing Comment

    extended the timeout and the completion was successful.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now