Run a job with linked tabless

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.

The jobs probably runs under your locale system account. Check on the sql server that this user has rights to access the server.

Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook