Re: Connection Problem - ASP to remote Access db

"MP" wrote in message news:42af1f96$1@post.newsfeeds.com...
: *** post for FREE via your newsreader at post.newsfeed.com ***
:
: I'm having a problem connecting to a Access DB on a remote computer (on
the
: intranet).
:
: This is the error I am getting:
: -----
: Microsoft JET Database Engine (0x80004005)
: The Microsoft Jet database engine cannot open the file
: '\\boswald_sci\sysdata\newdb.mdb'. It is already opened exclusively by
: another user, or you need permission to view its data.
: ---
:
: Here is are my connection(s) (notice when I use the local connection it
: works just fine):
:
: (REMOTE) strDBPath = "\\boswald_sci\sysdata\newdb.mdb"
: (LOCAL) strDBPath = Server.MapPath("newdb.mdb")
: Set cnnSearch = Server.CreateObject("ADODB.Connection")
: cnnSearch.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath
&
: ";"
:
: I have had a domain user created; this user has been added to the
: permissions (read, execute) on the database in question on the remote
: machine. I have set up IIS 5.1 to use that user as the anonymous user. So
: when I run the ASP file from the website it should use that user to
connect
: and get the data. There is no locked file in the directory.

To add to what Bob said...

Since you are connecting via UNC, it's easier to assign a group (LOCAL) to
have rights to that path (REMOTE). If it's a global group, then just put
those that need access in it and on the remote server add the global group
with the rights needed, generally MODIFY.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp