Re: Access Linked server generates (Error 7399) - Help!

Did you try putting a SQL Profiler trace on the job? That can be
invaluable in troubleshooting these kinds of problems.

--Mary

On Thu, 1 Sep 2005 15:54:02 -0700, AdsoftDesign
<AdsoftDesign@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I have created a linked server to an Access 2.0 database. I have a proc.
>that updates a table in the Access database. When executing the proc using
>Query Analyzer all works as it should. But, when I created a SQL Server Agent
>Job and attempt to run in on a schedule it fails with an error of:
>OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [SQLSTATE
>42000] (Error 7399) [SQLSTATE 01000] (Error 7312). The step failed.
>I have tried several variations of permissions with no luck. Any ideas?
.