Can't open DB on local machine?

[Aaron [SQL Server MVP]]

Why is it in C:? Put it in your web structure. And make sure you don't
have the database open in the Access GUI. Note that compact / repair can
reset the permissions on the file and/or the folder it's in. Did you check
the IUSR_ permissions?

[url]http://www.aspfaq.com/2009[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"MDW" <anonymous@discussions.microsoft.com> wrote in message
news:97FC12C4-96F2-44CE-B9A1-471F7B1A41E9@microsoft.com...

> Hey all,
>
> I'm having a strange problem opening an Access 2000 DB on my local

machine. It just started today. Whenever I view a page that attempts to open
a connection to the DB, I get the following error:

>
> "The Microsoft Jet database engine cannot open the file 'C:\Lookup.mdb'.

It is already opened exclusively by another user, or you need permission to
view its data."

>
> And no, I don't have it opened on my PC, nor can anyone access my C: drive

(that I know of). This worked fine on Friday, and the only thing I've done
since then was compact/repair the database. I've checked all the
security/sharing options I know to look at, and everything seems OK. Any
ideas?

>
> TIA.

[Ivo Stoykov]

You should include write permission to the folder where you DB is to
aspnet_wp account

Ivo

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message news:<ulaibvKTEHA.3752@TK2MSFTNGP12.phx.gbl>...

> Why is it in C:? Put it in your web structure. And make sure you don't
> have the database open in the Access GUI. Note that compact / repair can
> reset the permissions on the file and/or the folder it's in. Did you check
> the IUSR_ permissions?
>
> [url]http://www.aspfaq.com/2009[/url]
>
> --
> [url]http://www.aspfaq.com/[/url]
> (Reverse address to reply.)
>
>
>
>
> "MDW" <anonymous@discussions.microsoft.com> wrote in message
> news:97FC12C4-96F2-44CE-B9A1-471F7B1A41E9@microsoft.com...

> > Hey all,
> >
> > I'm having a strange problem opening an Access 2000 DB on my local

> machine. It just started today. Whenever I view a page that attempts to open
> a connection to the DB, I get the following error:

> >
> > "The Microsoft Jet database engine cannot open the file 'C:\Lookup.mdb'.

> It is already opened exclusively by another user, or you need permission to
> view its data."

> >
> > And no, I don't have it opened on my PC, nor can anyone access my C: drive

> (that I know of). This worked fine on Friday, and the only thing I've done
> since then was compact/repair the database. I've checked all the
> security/sharing options I know to look at, and everything seems OK. Any
> ideas?

> >
> > TIA.

[Aaron [SQL Server MVP]]

> You should include write permission to the folder where you DB is to

> aspnet_wp account

Did you mean to reply to me?

Anyway, for ASP, I think you meant IUSR_MachineName. ASP does not use
aspnet_wp ...

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)