ODBC - call failed during runing of macro Nancy 12/19/2008 2:02:19 PM Hi, I am running a nightly macro in Access to rebuild tables using an ODBC link with Microsoft Task Scheduler. This macro runs multiple macros. Once every week or so the macro is stopped & I receive Access error #2950. It always stops when the second sub-macro is run. I also get the ODBC--call failed error. It's very confusing because the first sub-macro uses the same ODBC link. Please help! -- Nancy

RE: ODBC - call failed during runing of macro Magius96 12/19/2008 7:43:04 PM This may help you: http://support.microsoft.com/default.aspx/kb/931407 "Nancy" wrote: [Quoted Text] > Hi, > I am running a nightly macro in Access to rebuild tables using an ODBC link > with Microsoft Task Scheduler. This macro runs multiple macros. Once every > week or so the macro is stopped & I receive Access error #2950. It always > stops when the second sub-macro is run. I also get the ODBC--call failed > error. It's very confusing because the first sub-macro uses the same ODBC > link. > > Please help! > -- > Nancy