[omrip21]

hi everyone
I have win xp pro with sp2 and mdac 2.8.
I have an asp app connected to an access database.
when i try to perform update,select or delete queries through asp ado returns this error:"the operation must use an updatable query".
i tried to change the parameters of the connection and the recordset use all of the methods(execute,open) and nothing worked
when i ran the query in vb and in access it worked..
I heard that the problem might be related to security defenition in IIS...
can anyone help me????
thanks!!! :hi:

[radarman012000]

This is simple. Your database is not writeable!.....You have to give your database write permissions. The error 'operation must use an updateable query' tell you this.

To make the changes, follow these steps.

1. Open IIS. Navigate to your database folder
2. Right click on the database itself and choose properties
3. Check the boxes "read" and "write"
4. Apply the changes and close IIS
5. You are done!

Most VB Script errors are self explanitory, but if you have one you don't understand, copy the error, number and all, and paste into a Google search box and presto! You will get all kinds of hits related to the error, some from Microsoft and most from forums that has dealt with the same issue.

Hope this helps