Change Default ODBC timout to 0

[sloshake]

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.

 

[jfgambit]

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

 

[GumbyD]

Check out this site it may give you what you want:

http://support.microsoft.com/default.aspx?scid=kb;en-us;153756

GumbyD

 

[sloshake]

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.

 

[namliam]

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

 

[sloshake]

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.

 

[namliam]

something like:

    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