RE: increase timout for queries

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for the help.


--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003


"BeWyched" wrote:

Hi

I've just tried the coding and it will change the Timeout setting on all
saved queries.

So use:

Dim qdfs As QueryDefs, qdf As QueryDef
Set qdfs = CurrentDb.QueryDefs
For Each qdf In qdfs
qdf.ODBCTimeout = 6000
Next

Good luck.

BW

"BillyRogers" wrote:

I'm talking about the saved queries in access. When you look at them in
design view and right click in the grey area in the top half of the QBE and
properties show up in a pop up. One of them is the timeout property. The
default is 60 and i want to change them all to 6000 the maximum. I'm trying
to avoid having to do this by hand for 60 queries. This happens in several
databases and this is something I could reuse often.

Thanks


--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003


"BeWyched" wrote:

Hi

I think I misunderstood your question with my last posting. I think you want
to change the timeout setting for existing queries, not the default for the
database.

I see that you are using SQL server so, presumably, your queries are ODBC
linked. If so then simply use:

Dim qdfs As QueryDefs, qdf As QueryDef
Set qdfs = CurrentDb.QueryDefs
For Each qdf In qdfs
qdf.ODBCTimeout = 30
Next

Change the 30 (seconds) to whatever setting you want.

egards.

BW

"BillyRogers" wrote:

Is there a way to have some code loop through all the queries in an access
database and increase the timeout?

I have a lot of Access Databases that I have to maintain that have 50 or 60
queries that are run sequentially and need to have their timeout property
increased. I've been doing this manually and it takes a very long time.
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003
.

Quantcast