OBDC timeout

Posted on 2011-10-25
Last Modified: 2012-05-12
I have a Pass-Through query in an MS Access (2007) database which times out on me.  How do I change the timeout value?  Thanks.
Question by:RishiSingh05
    LVL 12

    Expert Comment


    Author Comment

    The screen shots in the link show a Access 2000 file format.  Anyway,  when I am in SQL view I don't see a "View" command in the menu bar at the top.  I am therefore not able to get to Properties.
    LVL 12

    Accepted Solution

    You can go to the Properties of the SQL, click on Property Sheet, there you will see the settings.

    See attached screenshot:
     SQL ODBC Time Out

    Author Comment

    ok ,,, I changed the OBDC Timeout vale to 0  ,,, I believe that means no timeout, and I am now running the query ,,,
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    <<I believe that means no timeout, >>



    Author Comment

    Thanks ... it worked fine.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    This collection of functions covers all the normal rounding methods of just about any numeric value.
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    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…

    737 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

    19 Experts available now in Live!

    Get 1:1 Help Now