ASP.NET in DW 2004 "Problems Inserting Records into anAccess DB"

[JohnTIII]

Hi:

I am having problems inserting records into an Access 2003 DB. I am coding
with ASP.NET "VB".

I have no problems reading records, but for some reason when trying to insert
records I generate an error stating SystemData.OleDB.OleDBException: must use
an updateable query etc.......... Most of the literature I run across seems to
point to MDAC 2.8 along with SP2. I am using the simple insert procedure from
the applications menu within Dreamweaver. I ever pointed to a table with three
text columns and still no luck.

I've granted permissions to the IUSR account, so this is not the problem.
Entering incorrect data into a wrong data type is not a problem, since all I
have are text fields and I'm even trying two characters. Is there a fix
Macromedia posted that I don't know about or does someone know what this
problem my entail.

I'm hoping someone will be willing to help.

Respectfully,
John

[Paul Whitham TMM]

John

It is a permissions issue. Have a read through the article on
[url]www.charon.co.uk[/url] on where to change it, and particularly make sure that you
set the permissions for the ASP.Net Client as this is the one being called
and not the IUSR account

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"JohnTIII" <webforumsuser@macromedia.com> wrote in message
news:d6guqc$sf0$1@forums.macromedia.com...

> Hi:
>
> I am having problems inserting records into an Access 2003 DB. I am

coding

> with ASP.NET "VB".
>
> I have no problems reading records, but for some reason when trying to

insert

> records I generate an error stating SystemData.OleDB.OleDBException: must

use

> an updateable query etc.......... Most of the literature I run across

seems to

> point to MDAC 2.8 along with SP2. I am using the simple insert procedure

from

> the applications menu within Dreamweaver. I ever pointed to a table with

three

> text columns and still no luck.
>
> I've granted permissions to the IUSR account, so this is not the problem.
> Entering incorrect data into a wrong data type is not a problem, since all

I

> have are text fields and I'm even trying two characters. Is there a fix
> Macromedia posted that I don't know about or does someone know what this
> problem my entail.
>
> I'm hoping someone will be willing to help.
>
> Respectfully,
> John
>

[JohnTIII]

Paul:

Thank you!

John