Error executing Connection.Execute statement.

I'm using Windows XP with SP2. Whenever i try to INSERT a value or
Update a value in an ACCESS database i see this error "Operation must
use an updateable query."
I'm using ASP 3.0 with VBScript and ADO.
The same code with the same database is running on another pc. I dont
know what the fuck is this. I need immediate help as i'm doing a
professional proj.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Re: Error executing Connection.Execute statement.

"Khurram Hanif" wrote in message
news:OOe4znV8EHA.4072@TK2MSFTNGP10.phx.gbl...
>
> I'm using Windows XP with SP2. Whenever i try to INSERT a value or
> Update a value in an ACCESS database i see this error "Operation must
> use an updateable query."
> I'm using ASP 3.0 with VBScript and ADO.
> The same code with the same database is running on another pc. I dont
> know what the fuck is this. I need immediate help as i'm doing a
> professional proj.

This worked for me (pre SP2):

1) Open Control Panel then click Folder Options then scroll to the
bottom and turn off "Simple File Sharing"

2) Open Windows Explorer, right-click on the database's folder, click
Properties, click on the (now revealed) Security tab then select Everyone
then click the "Write" checkbox the click "Apply".