Change Default ODBC timout to 0

sloshake

New member
Local time
Today, 11:31
Joined
Dec 2, 2003
Messages
9
Is there a way to set it so that every query in a database has the ODBC timout set to 0 instead of 60?

Then whenever I create a new query in this database, the setting is already 0, instead of me having to change it from 60 to 0? Thanks.
 
Unfortunately, the default when creating a query is 60. The only way that I can think of is to create a New Query with no tables in it, set the ODBC to 0 seconds and save the Query as qryTempQuery. Then you can go into the Query add the tables and joins and save the Query using the SaveAs function.

HTH
 
I dont think IT is going to let me mess with my registry, and method 1 isnt going to always work from the description. As far as I understand it at least.

I know VBA for excel, but i'm not very good at it in Access.

I guess there isnt a way to say When a file is open, set the odbc timeout = 0, eh?

THanks for the help.
 
Well you could do a for each ... in ... next where you set the ODBC Timeout to 0 for each odbc passthrough query.... that might help....

(sorry for the late response, I was looking for something on ODBC and found your thread. I thought i might just be usefull.)

Regards
 
Do you know specifically what the code for this would be? I know VBA with Excel but have very little experience doing it with Access. Thank you for any help. Its still timely.
 
something like:
Code:
    Dim qdf As QueryDef
    For Each qdf In CurrentDb.QueryDefs
        If qdf.Type = dbQSQLPassThrough Then 'dbQSQLPassThrough = 112
            qdf.ODBCTimeout = 0
        End If
    Next qdf
Should do it you can all sorts of stuf like that even setting/changing the connectionstring if you so desire....

Hop you figure it from here :)

Regards
 

Users who are viewing this thread

Back
Top Bottom