OBDC timeout

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.
Who is Participating?
danishaniConnect With a Mentor Commented:
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
RishiSingh05Author Commented:
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.
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

RishiSingh05Author Commented:
ok ,,, I changed the OBDC Timeout vale to 0  ,,, I believe that means no timeout, and I am now running the query ,,,
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<I believe that means no timeout, >>


RishiSingh05Author Commented:
Thanks ... it worked fine.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.