I have tried to schedule a job either to run by SQL server or by "at". The job runs an executable made by vb, which automates Access and opens a mdb file. In the mdb file, there are a few tables linked to SQL server. But when it tries to run a query in the mdb file to access the linked tables, it pops the error "ODBC connection failed". The error never pops if I run it either from typing the command under DOS or by double cilcking the executable. Please help.