Linked server to Access problem

From: Robert (rzaborowski@cezar.pl)
Date: 11/25/02 

From: "Robert" <rzaborowski@cezar.pl>
Date: Mon, 25 Nov 2002 01:54:05 -0800

I have linked server to Access database on my SQL 2000
server (on Win 2000 serv.). The mdb file is on another
server (Win NT 4.0.). If I use sql login to connect to my
SQL 2000 server and query table from linked server
everything is ok. But if I use Windows Authentication
(domain\admin) I get: "Server: Msg 7399, Level 16, State
1, Line 1
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 '\\x\mydb.mdb'. It is already opened
exclusively
by another user, or you need permission to view its data.]"
I have mapped local login to Admin login of my Access
database.
I know that this problem has been already mentioned on
this group but I haven't found solution for my problem.
Thanks,
Robert

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)