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 Andre

Check out the archives for this list.  This problem comes up quite a bit:
http://p2p.wrox.com/search.asp?q=Microsoft+JET+Database+Engine+%280x80040E09
%29

Cheers
Darrell

-----Original Message-----
From: andre [mailto:andrewlwn@h...]
Sent: 05 October 2002 22:14
To: Access ASP
Subject: [access_asp] Help


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

I might be able to assist--but it would help if I could see the
code in question.

Larry Woods MCSD, MCT
l.woods, inc.

> -----Original Message-----
> From: andre [mailto:andrewlwn@h...]
> Sent: Saturday, October 05, 2002 10:14 PM
> To: Access ASP
> Subject: [access_asp] Help
>
>
> 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
>

a) Check NTFS permissions. If you are using Anonymous Authentication then
the IUSR_<machinename> account needs permissions to both the folder that the
Access file is in, and the file itself. It also needs permissions to the
c:\winnt\temp directory

b) Otherwise, you have have a readonly recordset, or you are attempting to
update a view (ie you joined several tables together). Please post your code

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "andre" <andrewlwn@h...>
Subject: [access_asp] Help


: 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.
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

At first glance at error message, check the permission of the database
and the directory it is stored in.  You may have the Read only checked,
this worked for me when I had that problem getting started.  What version of 
software [MS I assume] are you using?

Take care,
Chuck

> > -----Original Message-----
> > From: andre [mailto:andrewlwn@h...]
> > Sent: Saturday, October 05, 2002 10:14 PM
> > To: Access ASP
> > Subject: [access_asp] Help
> >
> >
> > 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