Run a job with linked tabless

[ygz]

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.

[Cakkie]

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