Hi Vinnie,  After settng iuser & wanuser permmissions, everything is working
ok until I open and then close the Access 2000 .mdb file.  After open/close,
the permissions revert back to default(?), even if I've unchecked "allow
inheritable permmissions from parent to propagate to this object".   I've
set the same permissions on every folder from the db folder on up through
the Inetpub folder.  Any ideas why this happens and/or how to prevent it?
Thanks,  Mike


----- Original Message -----
From: "Vinnie (Mailinglists Only)" <vinnie@j...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Sunday, August 25, 2002 1:23 AM
Subject: [asp_database_setup] Re: can't get asp to work with Access 2k


> >Thanks Vinnie.  I'm still having trouble with this.  It started working
> this
> > morning with the dsn conn string, but just stopped after a couple hours
> with
> > the following message.
>
>  Error Type:
>  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.
>
> => you still have a permission problem
>
> I next created an iuser account in Access 2000 (should it be
> iuser-[machinename] or just iuser), and put it in the Access user group,
> which has data read/write permission (but not to modify the design).  I
> rebooted but get the same error.  IIS still works because asp pages that
> don't interact with the database work fine.
> => you don't create in acces an Iuser. if you want to set the permission
> correct you go to the directory where your database is standing and there
> you ask the properties of that directory. Once you have done that you
should
> have there somewhere an Iuser and wanuser (I'm working now with XP and
thats
> also diffrent from win2k.) There shall stand iuser: read + wanuser: change
> (=read + write). they should have both change rights.
>
> I will check it on monday when I'm at the office
>
> >
> > Should I create an iuser account at the operating system level too?
> => he is already there
> >
> > This pc isn't running on a lan - it just has a dialup internet
connection.
> > What's the wanuser account for?
> wanuser = the editor, the one who can make changes. you needs that account
> also
>
> > Could you recommend a good article on the ins and outs of security setup
> for
> > a development machine with win2k pro, iis, asp3, Access2k, and
eventually
> > msde?  I've read some already, and understand authentication and
> > permissions, but am having trouble with setting up the various pieces.
> I've
> > recently migrated from win98se/pws/access97.
> >
> > Thanks again,
> > Mike
>
> good links are:
>
> www.4guysfromrolla.com
> www.aspin.com
> http://www.internet.com/sections/asp.html
>
>
>
> ----- Original Message -----
> From: "Mike" <mg188@c...>
> To: "ASP Database Setup" <asp_database_setup@p...>
> Sent: Saturday, August 24, 2002 11:55 PM
> Subject: [asp_database_setup] Re: can't get asp to work with Access 2k
>
>
> > Thanks Vinnie.  I'm still having trouble with this.  It started working
> this
> > morning with the dsn conn string, but just stopped after a couple hours
> with
> > the following message.
> >
> > Error Type:
> > 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.
> >
> > I next created an iuser account in Access 2000 (should it be
> > iuser-[machinename] or just iuser), and put it in the Access user group,
> > which has data read/write permission (but not to modify the design).  I
> > rebooted but get the same error.  IIS still works because asp pages that
> > don't interact with the database work fine.
> >
> > Should I create an iuser account at the operating system level too?
> >
> > This pc isn't running on a lan - it just has a dialup internet
connection.
> > What's the wanuser account for?
> >
> > Could you recommend a good article on the ins and outs of security setup
> for
> > a development machine with win2k pro, iis, asp3, Access2k, and
eventually
> > msde?  I've read some already, and understand authentication and
> > permissions, but am having trouble with setting up the various pieces.
> I've
> > recently migrated from win98se/pws/access97.
> >
> > Thanks again,
> > Mike
> >
> > ----- Original Message -----
> > From: "Vinnie (Mailinglists Only)" <vinnie@j...>
> > To: "ASP Database Setup" <asp_database_setup@p...>
> > Sent: Saturday, August 24, 2002 4:54 AM
> > Subject: [asp_database_setup] Re: can't get asp to work with Access 2k
> >
> >
> > > check the permission on the database
> > > Iuser and Wanuser should have read and write rights on the database.
> > >
> > > Greetings,
> > > Vinnie
> > >
> > > ----- Original Message -----
> > > From: "Mike" <mg188@c...>
> > > To: "ASP Database Setup" <asp_database_setup@p...>
> > > Sent: Friday, August 23, 2002 9:47 PM
> > > Subject: [asp_database_setup] can't get asp to work with Access 2k
> > >
> > >
> > > > I converted my Access97 to Access2k and tried running sql calls from
> the
> > > same asp pages.  I get the following error.
> > > >
> > > >
> > > > Error Type:
> > > > 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.
> > > >
> > > >
> > > > The setup on my devel pc:  Login to win2kpro as administrator. All
> site
> > > files (html, asp, db) are in folders under wwwroot (IIS5).
> > > > Function ocon sets up my connection string.  Both of the strings
below
> > > give the same error above.
> > > >
> > > >
> > > > function ocon()
> > > > set objcon = server.createobject("adodb.connection")
> > > > objCon.open "dsn=mg53r3db"
> > > > end function
> > > >
> > > > function ocon()
> > > > set objcon = server.createobject("adodb.connection")
> > > > objcon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > > > Source=c:\inetpub\wwwroot\mg53r3\mg53r3.mdb;"
> > > > end function
> > > >
> > > >
> > > > I triple-checked that the system dsn is set like I've always set it
> for
> > > use with Access 97.
> > > >
> > > > Within Access 2k, all groups and users have full permissions.  (I
know
> > > this probably isn't a good idea - I'll change this after I get the
> > > connection working).
> > > >
> > > > This is driving me bonkers - any advice?
> > > >
> > > > Thanks in advance,
> > > > Mike
> > > >
> > > >
> > vinnie@j...
> > > %%email.unsub%%
> > > >
> > > >
> > >
> > >
> > %%email.unsub%%
> > >
> > >
> > >
> >
> >
vinnie@j...
> %%email.unsub%%
> >
> >
>
>
%%email.unsub%%
>
>
>