Results 1 to 4 of 4
  1. #1
    thart21 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    83

    ODBC timeout message on query

    Does anyone know why, when I have an ODBC link to a large table, I can open the table just fine but, when I query on it, even with criteria in a date field for a single date (8/1/2011), it times out every time? I get the "ORA-01013 user requested cancel" message.



    Thanks!

    Toni

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    messages like this are all over google, bud. Use it. Literally google: ORA-01013 user requested cancel

    Access has been around for 20 years, and Oracle probably longer. Your issue has been mulled over more than a million times by pros, for sure.

  3. #3
    thart21 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    83
    Bud? Really? Do you really think I didn't Google it first? Come on, I was looking for some specific insight into my question to see if anyone else had come across it before and how they may have resolved it. A search here yielded nothing and "Googling" did not give me anything more than "contact your administrator", which I have done but not received a response from yet, but will keep trying.

    Also, I found no posts in which the user was able to open the table with no issues, but not query on it, I have also tried changing the timeout property of the query with no success.

    I always try to exhaust every resource I can think of before I post to these forums, of which I have been a member of since around 2002.

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Is your source table indexed? How large is the data set? Sometimes with very large data sets if they are not indexed you can have trouble calling queries.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Timeout Expired
    By Raj in forum Access
    Replies: 3
    Last Post: 05-04-2011, 09:51 PM
  2. ODBC -- call failed. | Oracle ODBC
    By drdexter33 in forum Access
    Replies: 1
    Last Post: 04-03-2010, 09:32 PM
  3. Linked Table and S1T00 timeout error
    By Jack A in forum Access
    Replies: 1
    Last Post: 01-22-2010, 09:14 PM
  4. ODBC and Long Query Time
    By pdouglas in forum Access
    Replies: 0
    Last Post: 07-09-2009, 10:21 AM
  5. Timeout Expired
    By brvaland in forum Database Design
    Replies: 0
    Last Post: 04-03-2009, 04:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums