Access VBA

Resolved · Urgent Priority · Version 2003

Fri 8 May 2009, 09:41 Delegate James said...

James has attended:
Access VBA course
Excel VBA Advanced course

Access VBA

Hiya, here is the description of what I am trying to do and what is going wrong.:

I am currently trying to run an sql make table query using the command 'cmd.runsql'.

Each time that I run the code I get an error message appear stating "Run-time error '3146'; ODBC --call failed, [Microsoft][ODBC SQL Server Driver] Timeout expired (#0)"

I have set the "ODBC query timeout" in the registry editor to 0. I have also coded the "OLE/DDE Timeout" and "CurrentDb().QueryTimeout" to 0 to no avail.

Does anyone know if there is a way to set the timeout for queries run via the "docmd.runsql" to 0 or to disable it completely, failing that does anyone know where I am going wrong and what I can do to fix this problem.

Many thanks in advance

Tue 12 May 2009, 15:25 Trainer Jacob said...

RE: Access VBA

Hello James

Okay to be of any help to you on this we will need to look at your source code in the actual database and take time out to identify what is going on.

This obviously exceeds any quick pointers via a post so if you want to look at this option in more detail please let us know.

regards

Jacob

Tue 19 May 2009: Automatically marked as resolved.

Training courses