ODBC Time-Out

wnfisba · Joined: 04 Oct 2007 Posts: 2

I have a SQL Query, an Access Pass-Through query that I have built in VB
within Access. It is timing out. Can anyone provide me the VBA syntax for
setting the ODBC timeout???

Any help would be GREATLY appreciated.

Thanks!

wnfisba

Archived from group: microsoft>public>vb>syntax

Richard Mueller · Joined: 04 Oct 2007 Posts: 15

"wnfisba" wrote in message @microsoft.com...
>I have a SQL Query, an Access Pass-Through query that I have built in VB
> within Access. It is timing out. Can anyone provide me the VBA syntax for
> setting the ODBC timeout???
>
> Any help would be GREATLY appreciated.
>
> Thanks!
>
> wnfisba

The Command object has a CommandTimeout property. The default is 30 seconds:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprocommandtimeout.asp

This link may also help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/searching_with_activex_data_objects_ado.asp

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net

Jeff Johnson · Joined: 04 Oct 2007 Posts: 1327

"Richard Mueller" wrote in message @TK2MSFTNGP02.phx.gbl...

>>I have a SQL Query, an Access Pass-Through query that I have built in VB
>> within Access. It is timing out. Can anyone provide me the VBA syntax for
>> setting the ODBC timeout???
>>
>> Any help would be GREATLY appreciated.
>>
>> Thanks!
>>
>> wnfisba
>
> The Command object has a CommandTimeout property. The default is 30
> seconds:
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprocommandtimeout.asp
>
> This link may also help:
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/searching_with_activex_data_objects_ado.asp

And those links are about ADO, which doesn't apply to Access's QueryDef
objects.

This question should be asked in an Access newsgroup. I recommend
microsoft.public.access.modulesdaovba. This group is for the full,
standalone version of VB.