Results 1 to 2 of 2

Thread: Timeout Error

  1. #1
    Join Date
    Aug 2003

    Unhappy Unanswered: Timeout Error

    I have linked SQL tables into Access. I'm getting a timeout error when running
    a query off the linked table. Any ideas on how to fix that.

  2. #2
    Join Date
    Mar 2004
    A query that uses an ODBC database as its underlying source of data might encounter delays due to network traffic or heavy use of the ODBC server.

    1) Open a query in Design view.

    2) Select the query by clicking anywhere in query Design view outside the design grid and the field lists.

    3) Click Properties on the toolbar to display the query's property sheet.

    4) Set the ODBCTimeout property to the number of seconds that the query waits before displaying a time-out error. The default is 60 seconds.

    Note: If you set the property to zero, no time-out error occurs.

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts