Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    9

    Unanswered: ODBC SQL Driver Timeout Expired from MS Access

    Hi

    I'm running a machine with windows xp pro sp2. I have a MS Access 2000 database on that machine. The database contains 1 odbc linked table
    and 1 Access query.

    The odbc linked table is connected to a MS SQL Server 2000 database with a ODBC SQL Server System DSN.

    The table on SQL Server to which the table in Access is linked has about
    3 million + rows.

    When I open the ODBC linked table in Access, it opens without a problem.

    However, if I use even so much as one criterion such as "where company = ABC" for example, then it "thinks" for a while and returns the dreaded:
    [Microsoft][ODBC SQL Driver] Timeout Expired (#0).

    I have to use MS Access 2000 as the front end for this SQL Database table.

    How do I get around the timeout issue. Is there a setting in SQL?

    Please keep in mind that
    I can't write the queries as Store procs because the requirement of the client is that there be one Linked Access table that the users can use
    to write various access queries. No user are not techies.

    please help

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    read this post:
    http://www.mcse.ms/message1582144.html

    I don't test.
    Tell me.
    Bye.

Posting Permissions

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