"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
>
>

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

"TomB" <shuckle@hotmail.com> wrote in message
news:OFnBX7knDHA.2808@TK2MSFTNGP10.phx.gbl...
> http://www.aspfaq.com/show.asp?id=2009
>
>
> "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 wrote:
> 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.

"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 http://www.aspfaq.com/2168
>
> 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.
>
>

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