|
|
You're in the
inetserver asp db
group:data access
inetserver asp db:
Hugh Welford wrote: Does the site have Anonymous access enabled?> Hi - trying to restore IIS in win XP pro with access2000 after > complete re-format in order to test a develpment website offline. > > IUSR_hughlaptop is set up as the internet user account, and this user > has been granted full access tp tyhe data file through the securities > tab. The directory hierarchy also been given full access share > permissions, and the database file reads on writes no problem within > acceess itself. But when I run an asp data access page i get > > Error Type: > Microsoft JET Database Engine (0x80040E09) > Cannot update. Database or object is read-only. > /daters/signin.asp, line 111 > > The directory hierarchy has read-only set to green, i.e. ON, an will > not be turned off > > Can anyone point me in the right direction here - getting very > frustrated - testing offline so dont really nneed any security at all. > http://www.aspfaq.com/show.asp?id=2062 http://www.aspfaq.com/show.asp?id=2009 -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
[quoted text, click to view]
Hugh Welford wrote: > Hi Bob - thanks for the reply. > > Yes, the site does have anonymous access enabled. The .mdb file does > not reside within the site directory though, and is kept in an > separate directory for access database files. Does this have a > bearing? Only if the IUSR (and sometimes IWAM) account has not been granted filesystem Change permissions for the folder containing the database. [quoted text, click to view] > Would it be better to keep the .mdb in the same directory as > the site? No, I never did that. [quoted text, click to view] > Before I had to reformat the hard drive I had it working Well, that answers the prior two questions, doesn't it?> with data in an external directory, but just cannot get it working > now. > -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
Hi - trying to restore IIS in win XP pro with access2000 after complete
re-format in order to test a develpment website offline. IUSR_hughlaptop is set up as the internet user account, and this user has been granted full access tp tyhe data file through the securities tab. The directory hierarchy also been given full access share permissions, and the database file reads on writes no problem within acceess itself. But when I run an asp data access page i get Error Type: Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only. /daters/signin.asp, line 111 The directory hierarchy has read-only set to green, i.e. ON, an will not be turned off Can anyone point me in the right direction here - getting very frustrated - testing offline so dont really nneed any security at all. Thanks Hugh
Hi Bob - thanks for the reply.
Yes, the site does have anonymous access enabled. The .mdb file does not reside within the site directory though, and is kept in an separate directory for access database files. Does this have a bearing? Would it be better to keep the .mdb in the same directory as the site? Before I had to reformat the hard drive I had it working with data in an external directory, but just cannot get it working now. Regards Hugh [quoted text, click to view] "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:%23hsA%23d4IHHA.420@TK2MSFTNGP06.phx.gbl... > Hugh Welford wrote: >> Hi - trying to restore IIS in win XP pro with access2000 after >> complete re-format in order to test a develpment website offline. >> >> IUSR_hughlaptop is set up as the internet user account, and this user >> has been granted full access tp tyhe data file through the securities >> tab. The directory hierarchy also been given full access share >> permissions, and the database file reads on writes no problem within >> acceess itself. But when I run an asp data access page i get >> >> Error Type: >> Microsoft JET Database Engine (0x80040E09) >> Cannot update. Database or object is read-only. >> /daters/signin.asp, line 111 >> >> The directory hierarchy has read-only set to green, i.e. ON, an will >> not be turned off >> >> Can anyone point me in the right direction here - getting very >> frustrated - testing offline so dont really nneed any security at all. >> > Does the site have Anonymous access enabled? > http://www.aspfaq.com/show.asp?id=2062 > http://www.aspfaq.com/show.asp?id=2009 > > > -- > Microsoft MVP -- ASP/ASP.NET > Please reply to the newsgroup. The email account listed in my From > header is my spam trap, so I don't check it very often. You will get a > quicker response by posting to the newsgroup. > >
[quoted text, click to view]
Hugh Welford wrote: Nope, I've never seen a case where these steps have failed. However,> Hi Bob, > > Thanks for your reply. > > Permissions for folder and dsatabase file changed to write for IUSR > and IWAM > > Also anonymous access enabled but problem persists. > > Any further ideas? > since you can open the database in Access and modify it's data, it's pretty clear that 1. the mdb file's read-only attribute is not checked and 2. there is definitely a permissions issue. Unfortunately, given that I cannot look at it firsthand, I cannot help you further. Sorry. -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
Hi Bob,
Thanks for your reply. Permissions for folder and dsatabase file changed to write for IUSR and IWAM Also anonymous access enabled but problem persists. Any further ideas? THanks Hugh [quoted text, click to view] "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:ui53Lo5IHHA.4712@TK2MSFTNGP04.phx.gbl... > Hugh Welford wrote: >> Hi Bob - thanks for the reply. >> >> Yes, the site does have anonymous access enabled. The .mdb file does >> not reside within the site directory though, and is kept in an >> separate directory for access database files. Does this have a >> bearing? > > Only if the IUSR (and sometimes IWAM) account has not been granted > filesystem Change permissions for the folder containing the database. > >> Would it be better to keep the .mdb in the same directory as >> the site? > > No, I never did that. > >> Before I had to reformat the hard drive I had it working >> with data in an external directory, but just cannot get it working >> now. >> > Well, that answers the prior two questions, doesn't it? > > -- > Microsoft MVP -- ASP/ASP.NET > Please reply to the newsgroup. The email account listed in my From > header is my spam trap, so I don't check it very often. You will get a > quicker response by posting to the newsgroup. > >
Thanks all the same
Regards Hugh [quoted text, click to view] "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:%23pXadUGJHHA.3916@TK2MSFTNGP02.phx.gbl... > Hugh Welford wrote: >> Hi Bob, >> >> Thanks for your reply. >> >> Permissions for folder and dsatabase file changed to write for IUSR >> and IWAM >> >> Also anonymous access enabled but problem persists. >> >> Any further ideas? >> > Nope, I've never seen a case where these steps have failed. However, > since you can open the database in Access and modify it's data, it's > pretty clear that > 1. the mdb file's read-only attribute is not checked and > 2. there is definitely a permissions issue. > > Unfortunately, given that I cannot look at it firsthand, I cannot help > you further. Sorry. > > > -- > Microsoft MVP -- ASP/ASP.NET > Please reply to the newsgroup. The email account listed in my From > header is my spam trap, so I don't check it very often. You will get a > quicker response by posting to the newsgroup. > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |