Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    15

    Question Unanswered: Error Messges coming while opening the Table

    Hi
    I am very much new to the MSAccess.

    After selecting Tables option from the MSAccess and selecting one Table and on opening(double click) it ,I am getting the following messages immediately while loading itself.

    1. ODBC- Call failed.
    2.[Microsoft][ODBC SQL Server Driver]Timeout expired(#0)

    Please anyone can help me in sorting out this error.It is very urgent.
    From where this message coming up and what should I do to stop them.

    Cheers,
    Ravi

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Question

    Check the connection to the SQL Server, try to ping the server and see whether you can reach it or not. I think it is a net work problem

  3. #3
    Join Date
    Sep 2003
    Posts
    15
    Originally posted by hammbakka
    Check the connection to the SQL Server, try to ping the server and see whether you can reach it or not. I think it is a net work problem
    Hi,
    Thank You for your suggestion
    After clicking OK on the two messages, I am able to get the data....
    In the meanwhile I will ping the server.

    Cheers,
    Ravi

  4. #4
    Join Date
    Sep 2003
    Posts
    15

    Take the Answer

    Hi,
    Set the timeout property to all the queries to 0
    It will never pou up you the messages again.
    Thanks to all who helped me to sort it out.

    Cheers,
    Ravi

Posting Permissions

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