Access Linked server generates (Error 7399) - Help!

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

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?
.

Follow-Ups:
- Re: Access Linked server generates (Error 7399) - Help!
  - From: Mary Chipman [MSFT]

Prev by Date: Re: Provider not found
Next by Date: Connection Pooling(Expecting Quick reply to get help)
Previous by thread: Re: Provider not found
Next by thread: Re: Access Linked server generates (Error 7399) - Help!
Index(es):
- Date
- Thread

Relevant Pages

ANSI defaults, Linked Server
... Access database that our Credit Card processing software uses. ... written a SP to grab some data from this Linked Server, and from my local SQL ... Enable these options and the reissue your query" ...
(microsoft.public.sqlserver.programming)
SQL Server 2005 - Linked Server (Access 2.0 file format)
... I'm trying to create a linked server to an access database (version ... The linked server was initially setup several months ago and all was ... OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ...
(microsoft.public.sqlserver)
Re: Linked SQL Server to Access
... I did not have my proxy set. ... >>> access database) ... >>> procedure to query data from the access database via a linked server, ... >>> the DTS, it works. ...
(microsoft.public.sqlserver.server)
Re: Linked server issue
... My access database is password protected too. ... > SQL Server logins to the Admin account of the Access database. ... In the Linked Server Properties dialog box of SQL Enterprise Manager. ... > (NOTICE that Access default Login is Admin and its password is NULL) ...
(microsoft.public.sqlserver.tools)
Re: Linked SQL Server to Access
... I did not have my proxy set. ... >>> access database) ... >>> procedure to query data from the access database via a linked server, ... >>> the DTS, it works. ...
(microsoft.public.sqlserver.dts)