Hi Everyone,

I have reach the point of madness, I am having a problem with one 
particular aspect of my application, which is basically the fact that I 
can read from my Access database which is fine. However when I try to 
insert data into it via my Register.asp page which in turn passes the 
values collected to the AddUser.asp page which holds all the underline 
codes it comes up with an erro message such as:

Error type:

microsoft JET Database Engine(0x80040E09) cannot Update. Database or 
object is read only.

Please help I am going mad. I have checked the connection strings over and 
over again.

Mark

Check the properties of both the database and the directory it is in.  Is 
file set to read only?  What are the security settings?  Just a couple of 
thoughts.
Regards,
Chuck



>From: "andre" <andrewlwn@h...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Help with updating Access databse
>Date: Sun, 13 Oct 2002 01:04:09
>
>Hi Everyone,
>
>I have reach the point of madness, I am having a problem with one
>particular aspect of my application, which is basically the fact that I
>can read from my Access database which is fine. However when I try to
>insert data into it via my Register.asp page which in turn passes the
>values collected to the AddUser.asp page which holds all the underline
>codes it comes up with an erro message such as:
>
>Error type:
>
>microsoft JET Database Engine(0x80040E09) cannot Update. Database or
>object is read only.
>
>Please help I am going mad. I have checked the connection strings over and
>over again.
>
>Mark




"If your not part of the solution,
there is good money to be made
prolonging the problem."
http://68.43.100.7:81/aa8vs


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

check if you have write access to the folder containing your database

Thanks for your input chuck.
The funny thing is I have checked this things you mentioned and everything 
seem to be ok. The file, Directory and Virtual Directory properties have 
been checked over and over again and the security settings and any other 
setting seem to be ok e.g the Read only attribute on the file or directory 
is not checked.  Another thing is the Access databse is located in my 
Inetpub\wwwroot\ directory. I don't know if this has any affect or not.
I still can read from the database Access fine.

Any ideas or input will be welcome.


> Check the properties of both the database and the directory it is in.  
Is 
file set to read only?  What are the security settings?  Just a couple of 
thoughts.
Regards,
Chuck



>From: "andre" <andrewlwn@h...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Help with updating Access databse
>Date: Sun, 13 Oct 2002 01:04:09
>
>Hi Everyone,
>
>I have reach the point of madness, I am having a problem with one
>particular aspect of my application, which is basically the fact that I
>can read from my Access database which is fine. However when I try to
>insert data into it via my Register.asp page which in turn passes the
>values collected to the AddUser.asp page which holds all the underline
>codes it comes up with an erro message such as:
>
>Error type:
>
>microsoft JET Database Engine(0x80040E09) cannot Update. Database or
>object is read only.
>
>Please help I am going mad. I have checked the connection strings over and
>over again.
>
>Mark




"If your not part of the solution,
there is good money to be made
prolonging the problem."
http://68.43.100.7:81/aa8vs


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

Let's start again. :-)

a) How are you updating the database? Can you post the relevant code? Are
you using a recordset (for example) which has an adLockReadOnly locktype?

b) What are the permissions on the folder that the database is in, and the
database itself? You say that "they have been checked", but what exactly are
they?

c) What about the Windows temp directory (c:\winnt\temp) - the Jet engine
puts temporary working files in that folder, so it needs access to it as
well.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "andre" <andrewlwn@h...>
Subject: [access_asp] Re: Help with updating Access databse


: Thanks for your input chuck.
: The funny thing is I have checked this things you mentioned and everything
: seem to be ok. The file, Directory and Virtual Directory properties have
: been checked over and over again and the security settings and any other
: setting seem to be ok e.g the Read only attribute on the file or directory
: is not checked.  Another thing is the Access databse is located in my
: Inetpub\wwwroot\ directory. I don't know if this has any affect or not.
: I still can read from the database Access fine.
:
: Any ideas or input will be welcome.
:
:
: > Check the properties of both the database and the directory it is in.
: Is
: file set to read only?  What are the security settings?  Just a couple of
: thoughts.
: Regards,
: Chuck
:
:
:
: >From: "andre" <andrewlwn@h...>
: >Reply-To: "Access ASP" <access_asp@p...>
: >To: "Access ASP" <access_asp@p...>
: >Subject: [access_asp] Help with updating Access databse
: >Date: Sun, 13 Oct 2002 01:04:09
: >
: >Hi Everyone,
: >
: >I have reach the point of madness, I am having a problem with one
: >particular aspect of my application, which is basically the fact that I
: >can read from my Access database which is fine. However when I try to
: >insert data into it via my Register.asp page which in turn passes the
: >values collected to the AddUser.asp page which holds all the underline
: >codes it comes up with an erro message such as:
: >
: >Error type:
: >
: >microsoft JET Database Engine(0x80040E09) cannot Update. Database or
: >object is read only.
: >
: >Please help I am going mad. I have checked the connection strings over
and
: >over again.
: >
: >Mark
:
:
:
:
: "If your not part of the solution,
: there is good money to be made
: prolonging the problem."
: http://68.43.100.7:81/aa8vs
:
:
: _________________________________________________________________
: MSN Photos is the easiest way to share and print your photos:
: http://photos.msn.com/support/worldwide.aspx
:

One last thought, are you running XP?  If so there is an Iuser
set of permissions that need to be set also.  XP allows a difference
between the user and user that comes via internet.  This one tripped
me up and Ken helped me out on this one.  There is some more information
if you could supply like code, system version, and this could help folks
to diagnose your problem.

Regards,
Chuck


>From: "andre" <andrewlwn@h...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Re: Help with updating Access databse
>Date: Mon, 14 Oct 2002 07:49:18
>
>Thanks for your input chuck.
>The funny thing is I have checked this things you mentioned and everything
>seem to be ok. The file, Directory and Virtual Directory properties have
>been checked over and over again and the security settings and any other
>setting seem to be ok e.g the Read only attribute on the file or directory
>is not checked.  Another thing is the Access databse is located in my
>Inetpub\wwwroot\ directory. I don't know if this has any affect or not.
>I still can read from the database Access fine.
>
>Any ideas or input will be welcome.
>
>
> > Check the properties of both the database and the directory it is in.
>Is
>file set to read only?  What are the security settings?  Just a couple of
>thoughts.
>Regards,
>Chuck
>
>
>
> >From: "andre" <andrewlwn@h...>
> >Reply-To: "Access ASP" <access_asp@p...>
> >To: "Access ASP" <access_asp@p...>
> >Subject: [access_asp] Help with updating Access databse
> >Date: Sun, 13 Oct 2002 01:04:09
> >
> >Hi Everyone,
> >
> >I have reach the point of madness, I am having a problem with one
> >particular aspect of my application, which is basically the fact that I
> >can read from my Access database which is fine. However when I try to
> >insert data into it via my Register.asp page which in turn passes the
> >values collected to the AddUser.asp page which holds all the underline
> >codes it comes up with an erro message such as:
> >
> >Error type:
> >
> >microsoft JET Database Engine(0x80040E09) cannot Update. Database or
> >object is read only.
> >
> >Please help I am going mad. I have checked the connection strings over 
>and
> >over again.
> >
> >Mark
>
>
>
>
>"If your not part of the solution,
>there is good money to be made
>prolonging the problem."
>http://68.43.100.7:81/aa8vs
>
>
>_________________________________________________________________
>MSN Photos is the easiest way to share and print your photos:
>http://photos.msn.com/support/worldwide.aspx
>




"If your not part of the solution,
there is good money to be made
prolonging the problem."
http://68.43.100.7:81/aa8vs


_________________________________________________________________
Join the world?s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

I have this problem before. Go back to the database connection. Make sure
you set it up to allow you edit and change rather than read only.

Julia

-----Original Message-----
From: andre [mailto:andrewlwn@h...]
Sent: Saturday, October 12, 2002 8:04 PM
To: Access ASP
Subject: [access_asp] Help with updating Access databse


Hi Everyone,

I have reach the point of madness, I am having a problem with one 
particular aspect of my application, which is basically the fact that I 
can read from my Access database which is fine. However when I try to 
insert data into it via my Register.asp page which in turn passes the 
values collected to the AddUser.asp page which holds all the underline 
codes it comes up with an erro message such as:

Error type:

microsoft JET Database Engine(0x80040E09) cannot Update. Database or 
object is read only.

Please help I am going mad. I have checked the connection strings over and 
over again.

Mark

Hi again everyone I am pleased to say I have finally solved the problem 
with your great input, especially Chuck and Ken who initially suggest I 
check the file settings.
I can now write to and update the Access database as was intended.

After lots of tantrums and hair tearing I am embarrassed to discover that 
the Security setting on the Access file was set to read only on the 
Everyone and system Group except for the Administrators group on the 
Security tab. That why I assumed all was well with the settings on the 
file and the directory that contain the file.

Once again thanks everyone, greatly appreciate your help

Mark

P.S. I am running Win2K Server for the benefit of those who want o know

















> I have this problem before. Go back to the database connection. Make sure
you set it up to allow you edit and change rather than read only.

Julia

-----Original Message-----
From: andre [mailto:andrewlwn@h...]
Sent: Saturday, October 12, 2002 8:04 PM
To: Access ASP
Subject: [access_asp] Help with updating Access databse


Hi Everyone,

I have reach the point of madness, I am having a problem with one 
particular aspect of my application, which is basically the fact that I 
can read from my Access database which is fine. However when I try to 
insert data into it via my Register.asp page which in turn passes the 
values collected to the AddUser.asp page which holds all the underline 
codes it comes up with an erro message such as:

Error type:

microsoft JET Database Engine(0x80040E09) cannot Update. Database or 
object is read only.

Please help I am going mad. I have checked the connection strings over and 
over again.

Mark