ASP and MSAccess

[JJWE webforumsuser@macromedia.com]

I am updating a MSAccess DB from a web page. I can read the database with no problem but my update and insert script are having problems.
Example:
INSERT INTO Inventory ( stock_num, year, cash_pay, down_pay, payment,image_sm, image_lg, Description) VALUES ( 'CH00099', '2005', 0, 695, 1200, '?????', '?????', 'This is a Test' )

where "Inventory" is a MSAccess table returns:
***
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

managebikes.asp, line 96
***
Line 96 is the line to execute the script --> "Con.Execute sqlString" where sqlstring is the INSERT script above.

I don't understand the problem here.

Also my UPDATE script is:
UPDATE Inventory SET year='2002', cash_pay=0, down_pay=500, payment=179, image_sm='small.jpg',image_lg='large.jpg', Description='XL 883 Custom - Black with 4300 miles' WHERE rTrim(lTrim(stock_num))='CH025'

Again, Inventory is a MSAccess table. The following error msg it returned
***
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

managebikes.asp, line 128
***
Line 128 is the line to execute the script --> "Con.Execute sqlString" where sqlstring is the UPDATE script above.

I don't understand thisproblem either. it is alomost identical to a script I use on another website to update a MSSQLServer DB, and it works fine there.

Thanks in advance
John

[Showpony]

It's a write permissions issue.
The application development forum has a thread on this
[url]http://webforums.macromedia.com/dreamweaver/messageview.cfm?catid=263&thread[/url]
id=698827
You should find the solution here

Cheers
Anna


"JJWE" <webforumsuser@macromedia.com> wrote in message
news:bl7ac1$8g2$1@forums.macromedia.com...

> I am updating a MSAccess DB from a web page. I can read the database with

no problem but my update and insert script are having problems.

> Example:
> INSERT INTO Inventory ( stock_num, year, cash_pay, down_pay,

payment,image_sm, image_lg, Description) VALUES ( 'CH00099', '2005', 0, 695,
1200, '?????', '?????', 'This is a Test' )

>
> where "Inventory" is a MSAccess table returns:
> ***
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable

query.

>
> managebikes.asp, line 96
> ***
> Line 96 is the line to execute the script --> "Con.Execute sqlString"

where sqlstring is the INSERT script above.

>
> I don't understand the problem here.
>
> Also my UPDATE script is:
> UPDATE Inventory SET year='2002', cash_pay=0, down_pay=500, payment=179,

image_sm='small.jpg',image_lg='large.jpg', Description='XL 883 Custom -
Black with 4300 miles' WHERE rTrim(lTrim(stock_num))='CH025'

>
> Again, Inventory is a MSAccess table. The following error msg it returned
> ***
> Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
>
> [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
>
> managebikes.asp, line 128
> ***
> Line 128 is the line to execute the script --> "Con.Execute sqlString"

where sqlstring is the UPDATE script above.

>
> I don't understand thisproblem either. it is alomost identical to a

script I use on another website to update a MSSQLServer DB, and it works
fine there.

>
> Thanks in advance
> John
>
>
>
>
>
>
>
>