I'm working through the Wrox Beginning ASP 3.0 book and I get errors when attempting to do any of the exercises that modify data. This applies to those that add/change/delete data in the (Access) database or the exercise that uses a record object to copy, move or delete a file.

I'd appreciate any help on how to resolve this problem.

Here's a bit more detail:
With a SQL command, the error is "Operation must use an updateable query."
With a recordset, the error is "Current Recordset does not support updating."
With a record object, the error is "Server cannot complete the operation."

Hi

This sounds like you are using something like an Access database
and the folder that it resides in does not have write permissions for the web user account [IUSR_machineName]

If this is the case you will need to change the permissions on the folder to include the above named user account.

Hope this helps

Thanks. I'm mildly familiar with permissions on an NT network, but I'm on a standalone home PC. Does this still apply, and if so, how would I do this?

1. Select yur .mdb file
2. Right click and choose "Properties"
3. Click on "Security" tab
4. Click on Add Button
5. Enter your_machine_name\IUSR_your_machine_name
6. On the list of users another one user is displayed named "Internet Guest Account (your_machine_name\IUSR_your_machine_name)
7. Click on Apply



...but the Soon is eclipsed by the Moon

Thanks, NotNowJohn. I'm running Windows XP and on File Properties a "Security" tab is not an option.

The Folder Properties dialog does have a "Web Sharing" tab. I have it set to "Share this folder" on the Default Web Site - but that doesn't seem to resolve my problem.


I've discovered that this folder - and actually all other folders - are set to "Read-only" and for some reason, this attribute can't be changed. If I de-select "Read-only", then "Apply", the attribute is still set to "Read-only" the next time I open the dialog. So, I'm going to explore how to fix this and see if it resolves the problem.

1. Open one of the Explorer's windows.
2. Choose Tools/Folder Options
3. Click on View tab
4. On the list check the last item named:
Use simple file sharing(Recommended) (on your comp has checked)
5. Unchecked it
6. Click on Apply btn.



...but the Soon is eclipsed by the Moon

Again, Thanks. I set the folder options as you suggested to uncheck simple file sharing. This did not resolve the ASP SQL UPDATE problem.

I'm still looking into the Read-Only attribute not being changeable.

oops, sorry I have not completed the solution...

You have to click on the Properties of the file, and on the Security tab choose newly added user (Internet Guest Account) and in the below window you can see the privilegies for that user on that file.
In order to allow write permissions for this user you have to check the checkbox near "Write".
After adding a new user, his default permissions are Read & Execute and Read.



...but the Soon is eclipsed by the Moon

It worked - thanks so much for staying with me through this - and for the lesson on setting permissions! I really appreciate your help.

np :)

...but the Soon is eclipsed by the Moon