Re: OK, here's what i tried...
From: Roger Abell [MVP] (mvpNOSPAM@asu.edu)
Date: 04/05/03
- Next message: Bob G: "Internet Firewall"
- Previous message: Roger Abell [MVP]: "Re: help"
- In reply to: Rob: "OK, here's what i tried..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Roger Abell [MVP]" <mvpNOSPAM@asu.edu> Date: Sat, 5 Apr 2003 12:52:21 -0700
I believe that your clue is in the ODBC error message
where it says file '(unknown)'
Usually it will give the filepath here, so it looks like
something is wrong with the filename it is being
asked to open.
Was this web created by yourself ? In FrontPage?
-- Roger "Rob" <nnnn@nnnn.com> wrote in message news:046f01c2fb76$d0d79fe0$a301280a@phx.gbl... > I added the IWAM_machine account with no effect. > I tried to deleted everything but it would only let > delete the new one. The others were set by a higher > folder. I went up to the WWWRoot directory and deleted > everything (permissions wise) except forAdministrators > (PoppasOffice\administrators) and SYSTEM both whioch have > full control. > I then clicked ADD. > i typed in IUSR_POPPASOFFICE and clicked search users. > It changed it to: POPPASOFFICE\IUSR_POPPASOFFICE > I added it and set rights to full. > Still the same error. > I added IWAM_POPPASOFFICE and it changed it to : > POPPASOFFICE\IWAM_POPPASOFFICE > I assigned full control. > Still the same error. > Went to the DB directory and verified that i see those > groups with the expected permissions. Looks fine. > Noticed the CREATOR OWNER was on that folder after i > removed it above. Removed it successfully. > Returned to the wwwroot dir. > Removed it there. readded it and sved the setting. > It now appeared on the DB folder. Permissions on wwwroot > and DB folder are still blank. > Assumed you are correct and it can be ignored. > ASP to DB still returns this error: > Microsoft OLE DB Provider for ODBC Drivers (0x80004005) > [Microsoft][ODBC Microsoft Access Driver] The Microsoft > Jet database engine cannot open the file '(unknown)'. It > is already opened exclusively by another user, or you > need permission to view its data. > > Sorry for the legnthy message but i think only details > will save me now. > > Thanks for your help! > Rob > >-----Original Message----- > >AFAIK a grant to Creator Owner is irrelevant. > >The folder that contains the mdb, perhaps .\fpdb if you > >are using FrontPage and storing the mdb within the web > >content, needs to have a grant of modify for the > accounts > >that IIS will use. The folder, not just the mdb, but > make > >sure the grants inherit to the mdb. > >Now, what accounts ? IUSR_machine if you are using > >anonymous web in process, IWAM_machine if anonymous > >and you use process isolation, and any account allowed > to > >browse the web if it is not an anonymous access web. > > > >-- > >Roger > > > >"Rob" <noemail@noemail.com> wrote in message > news:031101c2fb2b$eda42bc0$a301280a@phx.gbl... > >> Ok, all i did was run the compress and rebuild utility > in > >> an access2000 db. Now i can't access any pages that > use > >> that DB. From what i gather, the utility also manages > to > >> erase permissions to the file. I have verified that > >> security permission to IUSR_Machine are RWX but i was > >> also told that the group Creator Owner must be at full > >> control. No matter at what folder level i look at, > the > >> permissions for that group are all blank. If i set it > to > >> full control, as soon as i click APPLY, they all > >> disappear. > >> 1.) is this the problem, that i need to reset > permissions > >> for the Creator owner group? > >> 2.) How can i do that? Please don't refer me to a > >> knowledge base page. They are basically useless. I > am > >> tired of reading pages that describe my problem then > >> say "to correct the problem, reset the privaliges" > >> or "this is a planned result". I've been dead in the > >> water for two days now... > >> 3.) why on earth (hypothetical question) would it make > >> sense for a compress rebuid function to mess around > with > >> features outside of the DB? God forbid if i add gas > to > >> my car and find out afterwards doing so requires that > you > >> go around the car and reconnect any fuel lines because > >> adding fuel causes them all to diconnect. Sorry - > just > >> frustrated. I obviously only know enough to get me > into > >> trouble and not enough to get out. > >> > >> Thanks! > >. > >
- Next message: Bob G: "Internet Firewall"
- Previous message: Roger Abell [MVP]: "Re: help"
- In reply to: Rob: "OK, here's what i tried..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
