Can't query linked Access database specified by UNC

From: Vadim Rapp (vrapp_at_nospam.polyscience.com)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 13:35:38 -0600

Hello,

I link Access database to sql server 2000 with ole db 4 provider; tell it to
logon with username ADMIN, empty password.

If the database is on a local drive, everything works correctly, I see the
tables of the access database in EM, and I successfully run query like
select * from accessdb...table1

If the database is on a remote drive and is specified by UNC, I still see
the tables in EM when EM runs on the server; but when I run EM on another
machine, focusing the tables under the linked server returns error
0x80004005. Same when I try to run a query (even on the server):

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: The Microsoft Jet database engine cannot
open the file '\\server\share\accessdb.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].

Sql server is running on domain administrative account. At the same time as
the message is issued, I can log on that account on the server, launch
Access, and successfully open that same remote database using the same UNC
path.

What gives?

thanks,

Vadim Rapp
Polyscience, Inc.

Relevant Pages

  • Re: Profile Problem
    ... you need the Access provider. ... I added some profile properties to my web.config file. ... An error has occurred while establishing a connection to the server. ... using a database location within the applications App_Data directory. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Paging - ADO.NET 2.0
    ... I was under the impression that additional information was sent to server ... from the provider when such a query is made. ... Thus allowing the database engine server-side to move the cursor to whatever ...
    (microsoft.public.dotnet.framework.adonet)
  • adsi linked servers
    ... I'm following the directions for the OLE DB Directory ... I add the linked server with this TSQL ... from OLE DB provider 'ADSDSOObject'". ... If I execute an openquery command from query analyzer I ...
    (microsoft.public.sqlserver.security)
  • Re: Website Development
    ... Your programming experience would cross translate to: ... Once a web server has deliverd its requested ... >|> The database and language used will depend upon the service provider ... But you would have to ensure the new provider catered for the language ...
    (microsoft.public.scripting.jscript)
  • Re: question about mining external databases and exporting mining models into pmml
    ... have a provider that we can work with (OLE DB provider or .Net data ... I think Oracle has both an OLE DB provider and a managed ... On the second question: models' PMML may be exported with a statement like: ... database on sql server database engine. ...
    (microsoft.public.sqlserver.datamining)