data access

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

Re: data access

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.

Re: data access

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



"Bob Barrows [MVP]" 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.
>
>

Re: data access

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.

Re: data access

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


"Bob Barrows [MVP]" 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.
>
>

Re: data access

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.

Re: data access

Thanks all the same

Regards Hugh


"Bob Barrows [MVP]" 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.
>
>