Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server time out

Status
Not open for further replies.
vbajock

vbajock

Programmer
Jun 8, 2001
1,921
US
When executing queries against a large (200,000 records) SQL Server 2000 table using the Access user query interface, I am getting timeout errors that cancel the query before data is returned. Does anyone know whether the time out value is set in Access or SQL Server and if so, where ?
Thanks!
 
Sort by date Sort by votes
Try setting the query's ODBCTimeout Property (via View menu, Properties, ODBC Timeout or via code) value = 0

Check out the Access help on ODBCTimeout. Jim Kraxberger
Developing Access solutions since 1995
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Aurillius
  • Locked
  • Question
Convert Date/Time cell to a date and time in VBA
Replies
2
Views
789
Andrzejek
Andrzejek
EM1107
  • Locked
  • Question
calculated time difference. 1
Replies
2
Views
729
strongm
strongm
lameid
  • Locked
  • Question
ADO UpdateBatch SQL Server Example?
Replies
2
Views
317
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Add multiple contacts to outlook - from access table
Replies
12
Views
502
Moss100
Moss100
nikademous
  • Locked
  • Question
Run Time Error 6 Overflow
Replies
4
Views
291
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top