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 second time it tries to execute but fails due to an odbc connection error. The only way I can run the pass-through query again is by closing and reopening the ms access database.
Desparately need help.