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