Returned error is as follows:
"ODBC--connection to 'SVRabc' failed."
Code is as follows:
'first time works
Dim qd1 As QueryDef
Set qd1 =...
Submit Your Article
Forum Rules
Type: Posts; User: vns; Keyword(s):
Returned error is as follows:
"ODBC--connection to 'SVRabc' failed."
Code is as follows:
'first time works
Dim qd1 As QueryDef
Set qd1 =...
I am using ms access as a frontend & sql svr 2008 as a backend. The same pass-through query is being executed at two different points in the vba. The first time it executes with no problem. The...