asp/database on network error

[Norm]

Using NT4.0 sp6, IIS4, Access2002
Mercy if this has been answered a hundred times. I've googled and I've
found some information on aspfaq.com which pertained to Win2000, but the
principles seemed the same. So far no solution.

I use asp to search a database on my Web server. While I can connect and
search a database that exists on my web server, I can't seem to use this
process on another database which is on another server. The error is at the
bottom of this email and seems to be permissions related.

I'm using IUSR_MYSERVER on the web server for Anonymous Access /
Authentication.

On the server that holds the Access database, I've given user,
IUSR_MYSERVER the appropriate read/write permissions.

I can log on as IUSR_MYSERVER onto a workstation and get the database and
open it with Access using the same UNC path which shows in the error(below).

And yet I'm getting this error (below)-
Any thoughts or help?
Thanks
Norm
################################################## #
Microsoft JET Database Engine error '80004005'

The Microsoft Jet database engine cannot open the file '\\myserver\test
data\Registrar\Access2002\studentcourses2002.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.

/mmaonly/studentsearch.asp, line 20
################################################## ##

[Bob Barrows]

This article should contain your answer:
[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;253580[/url]

The IUSR_MYSERVER account needs to be a domain account, not local, in order
to access the remote database. In addition, it needs Change permissions
(read/write) on the folder containing the database, not just the database
itself. It needs to be able to create, write to, and delete lock files
(.ldb) in that folder.

HTH,
Bob Barrows

Norm wrote:

> Using NT4.0 sp6, IIS4, Access2002
> Mercy if this has been answered a hundred times. I've googled and
> I've found some information on aspfaq.com which pertained to Win2000,
> but the principles seemed the same. So far no solution.
>
> I use asp to search a database on my Web server. While I can connect
> and search a database that exists on my web server, I can't seem to
> use this process on another database which is on another server. The
> error is at the bottom of this email and seems to be permissions
> related.
>
> I'm using IUSR_MYSERVER on the web server for Anonymous Access /
> Authentication.
>
> On the server that holds the Access database, I've given user,
> IUSR_MYSERVER the appropriate read/write permissions.
>
> I can log on as IUSR_MYSERVER onto a workstation and get the database
> and open it with Access using the same UNC path which shows in the
> error(below).
>
> And yet I'm getting this error (below)-
> Any thoughts or help?
> Thanks
> Norm
> ################################################## #
> Microsoft JET Database Engine error '80004005'
>
> The Microsoft Jet database engine cannot open the file
> '\\myserver\test data\Registrar\Access2002\studentcourses2002.mdb'.
> It is already opened exclusively by another user, or you need
> permission to view its data.
>
> /mmaonly/studentsearch.asp, line 20
> ################################################## ##

[Norm]

Gosh - I printed followed that KB253580 article to the letter and am still
getting the same error. Grrrrrrr.

I'm double checking everything now, but any other thoughts as how to
approach this????

Thanks
Norm

"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:um7s0uJeDHA.1760@TK2MSFTNGP09.phx.gbl...

> This article should contain your answer:
> [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;253580[/url]
>
> The IUSR_MYSERVER account needs to be a domain account, not local, in

order

> to access the remote database. In addition, it needs Change permissions
> (read/write) on the folder containing the database, not just the database
> itself. It needs to be able to create, write to, and delete lock files
> (.ldb) in that folder.
>
> HTH,
> Bob Barrows
>
> Norm wrote:

> > Using NT4.0 sp6, IIS4, Access2002
> > Mercy if this has been answered a hundred times. I've googled and
> > I've found some information on aspfaq.com which pertained to Win2000,
> > but the principles seemed the same. So far no solution.
> >
> > I use asp to search a database on my Web server. While I can connect
> > and search a database that exists on my web server, I can't seem to
> > use this process on another database which is on another server. The
> > error is at the bottom of this email and seems to be permissions
> > related.
> >
> > I'm using IUSR_MYSERVER on the web server for Anonymous Access /
> > Authentication.
> >
> > On the server that holds the Access database, I've given user,
> > IUSR_MYSERVER the appropriate read/write permissions.
> >
> > I can log on as IUSR_MYSERVER onto a workstation and get the database
> > and open it with Access using the same UNC path which shows in the
> > error(below).
> >
> > And yet I'm getting this error (below)-
> > Any thoughts or help?
> > Thanks
> > Norm
> > ################################################## #
> > Microsoft JET Database Engine error '80004005'
> >
> > The Microsoft Jet database engine cannot open the file
> > '\\myserver\test data\Registrar\Access2002\studentcourses2002.mdb'.
> > It is already opened exclusively by another user, or you need
> > permission to view its data.
> >
> > /mmaonly/studentsearch.asp, line 20
> > ################################################## ##

>
>

[Bob Barrows]

Nope - I've never attempted to use a Jet database on another machine. AFAIK,
if you do everything that article tells you to do, you should be able to
connect.

Sorry,
Bob Barrows
Norm wrote:

> Gosh - I printed followed that KB253580 article to the letter and am
> still getting the same error. Grrrrrrr.
>
> I'm double checking everything now, but any other thoughts as how to
> approach this????
>
> Thanks
> Norm
>
> "Bob Barrows" <reb_01501@yahoo.com> wrote in message
> news:um7s0uJeDHA.1760@TK2MSFTNGP09.phx.gbl...

>> This article should contain your answer:
>> [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;253580[/url]
>>
>> The IUSR_MYSERVER account needs to be a domain account, not local,
>> in order to access the remote database. In addition, it needs Change
>> permissions (read/write) on the folder containing the database, not
>> just the database itself. It needs to be able to create, write to,
>> and delete lock files (.ldb) in that folder.
>>
>> HTH,
>> Bob Barrows
>>
>> Norm wrote:

>>> Using NT4.0 sp6, IIS4, Access2002
>>> Mercy if this has been answered a hundred times. I've googled and
>>> I've found some information on aspfaq.com which pertained to
>>> Win2000, but the principles seemed the same. So far no solution.
>>>
>>> I use asp to search a database on my Web server. While I can connect
>>> and search a database that exists on my web server, I can't seem to
>>> use this process on another database which is on another server.
>>> The error is at the bottom of this email and seems to be
>>> permissions related.
>>>
>>> I'm using IUSR_MYSERVER on the web server for Anonymous Access /
>>> Authentication.
>>>
>>> On the server that holds the Access database, I've given user,
>>> IUSR_MYSERVER the appropriate read/write permissions.
>>>
>>> I can log on as IUSR_MYSERVER onto a workstation and get the
>>> database and open it with Access using the same UNC path which
>>> shows in the error(below).
>>>
>>> And yet I'm getting this error (below)-
>>> Any thoughts or help?
>>> Thanks
>>> Norm
>>> ################################################## #
>>> Microsoft JET Database Engine error '80004005'
>>>
>>> The Microsoft Jet database engine cannot open the file
>>> '\\myserver\test data\Registrar\Access2002\studentcourses2002.mdb'.
>>> It is already opened exclusively by another user, or you need
>>> permission to view its data.
>>>
>>> /mmaonly/studentsearch.asp, line 20
>>> ################################################## ##