Jet Error 0x80004005

[TomB]

[url]http://www.aspfaq.com/show.asp?id=2009[/url]


"Si" <nospam@nospam.com> wrote in message
news:%23G6CY3knDHA.1708@TK2MSFTNGP12.phx.gbl...

> Hi
>
> I am saving data from ASP to an access database which has linked tables, i
> keep getting this errror:
>
> Microsoft JET Database Engine (0x80004005)
> The Microsoft Jet database engine cannot open the file 'I:\Access
> Database\980211be.mdb'. It is already opened exclusively by another user,

or

> you need permission to view its data.
> /js_03.asp, line 23
>
> The problem is that this is the linked database, and that i do have
> permission to acceess it, there are no other processes running that could

be

> accessing it.
>
> I am very lost, any help would be great
>
> Cheers Si
>
>

[Si]

Hi

I am saving data from ASP to an access database which has linked tables, i
keep getting this errror:

Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'I:\Access
Database\980211be.mdb'. It is already opened exclusively by another user, or
you need permission to view its data.
/js_03.asp, line 23

The problem is that this is the linked database, and that i do have
permission to acceess it, there are no other processes running that could be
accessing it.

I am very lost, any help would be great

Cheers Si

[Si]

Hi Tom

I have been though everything on that page before trying to solve this one.

Any other ideas?

Thanks Si

"TomB" <shuckle@hotmail.com> wrote in message
news:OFnBX7knDHA.2808@TK2MSFTNGP10.phx.gbl...

> [url]http://www.aspfaq.com/show.asp?id=2009[/url]
>
>
> "Si" <nospam@nospam.com> wrote in message
> news:%23G6CY3knDHA.1708@TK2MSFTNGP12.phx.gbl...

> > Hi
> >
> > I am saving data from ASP to an access database which has linked tables,

i

> > keep getting this errror:
> >
> > Microsoft JET Database Engine (0x80004005)
> > The Microsoft Jet database engine cannot open the file 'I:\Access
> > Database\980211be.mdb'. It is already opened exclusively by another

user,

> or

> > you need permission to view its data.
> > /js_03.asp, line 23
> >
> > The problem is that this is the linked database, and that i do have
> > permission to acceess it, there are no other processes running that

could

> be

> > accessing it.
> >
> > I am very lost, any help would be great
> >
> > Cheers Si
> >
> >

>
>

[Aaron Bertrand - MVP]

> I have been though everything on that page before trying to solve this
one.

I assume I:\ is a mapped drive to another machine. If you are using
anonymous access, and IUSR_webserver is not explicitly set up on the machine
where I:\ lives, then that user will *not* have access to a file there. Do
not make the mistake of thinking everyone in the world is included in the
"everyone" group.

The very first error block in article #2009 mentions this scenario (using a
remote share). To wit:

"This can also mean you are attempting to connect to an MDB file on a remote
share; if so, see Article #2168 and KB #189408 for more information."

So, see [url]http://www.aspfaq.com/2168[/url]

Better yet, consider using a real database, or at least keep the database
and the web server on one machine. You're losing enough efficiency using
Access at all, you're only making it worse by keeping them separated by
wires.

[Si]

Hi Aaron

I followed that artical yesterday and setup a "IUSR_Recall
(APPLICATIONNET\IUSR_Recall" account on the server, i have given them full
control privilages (to be revised when i have found the problem) and i have
set the same password in IIS/Annonymous Access.

I am against a brick wall with the choice of Access and the backend must
reside on a different machine. I have attempted to not use linked tables,
but i get the same error message. I have attempted to use ODBC to connect
to the backend from ASP with no luck.

I have been through it all again, to check that i havent missed anything and
it is all setup as noted on the website.

Any other ideas on the problem,

Thanks Si

"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:eS6okplnDHA.2000@TK2MSFTNGP12.phx.gbl...

> > I have been though everything on that page before trying to solve this

> one.
>
> I assume I:\ is a mapped drive to another machine. If you are using
> anonymous access, and IUSR_webserver is not explicitly set up on the

machine

> where I:\ lives, then that user will *not* have access to a file there.

Do

> not make the mistake of thinking everyone in the world is included in the
> "everyone" group.
>
> The very first error block in article #2009 mentions this scenario (using

a

> remote share). To wit:
>
> "This can also mean you are attempting to connect to an MDB file on a

remote

> share; if so, see Article #2168 and KB #189408 for more information."
>
> So, see [url]http://www.aspfaq.com/2168[/url]
>
> Better yet, consider using a real database, or at least keep the database
> and the web server on one machine. You're losing enough efficiency using
> Access at all, you're only making it worse by keeping them separated by
> wires.
>
>

[Bob Barrows]

Si wrote:

> Hi Aaron
>
> I followed that artical yesterday and setup a "IUSR_Recall
> (APPLICATIONNET\IUSR_Recall" account on the server, i have given them

I'm a little confused by your description, so I want to verify that
APPLICATIONNET\IUSR_Recall is a domain-level account. It sounds like it is
(who would name a machine ":APPLICATIONNET", right?), but I just want to be
sure

> full control privilages (to be revised when i have found the problem)

This is not necessary. Only Change permissions on the folder containing the
database file are needed.

> and i have set the same password in IIS/Annonymous Access.

Have you caused the local IUSR account to run as the domain-level account?
This is done with IIS Manager.

Depending on what context you are running your application in, you may need
to do the same thing with the IWAM account.

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[John Beschler]

>>you're only making it worse by keeping them separated by
wires.

Does that mean it will work better if he switches to a
wireless network? :)


Sorry, Aaron. I couldn't resist!

John