Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Access VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access VBA
Resolved · Urgent Priority · Version 2003
Reply Fri 8 May 2009, 09:41Delegate 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
For upcoming training course dates see: Pricing & availability
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.
|