I am in XP prof, IIS 5.1
I have no user = ASPNet. But I am having a similar problem with adding and updating vfp data files. I can however read them with no problems/
Any thoughts on how to proceed?
Neil
>Could be related to write access to this folder for the user.
>
>Recently I had a partially similar problem accessing MDB file via OleDb. All SELECTs worked, but INSERTs and UPDATEs returned an error message: Operation must use an updateable query.
>
>I found an answer:
>If you're getting an error when Inserting or Updating an MS Access Database
>('Operation must use an updateable query'), that's because the ASPNet user
>account needs the correct permissions on the directory where the database
>resides
>To fix this in Windows 2K:
>Go into Accessories/Computer Management/Local Users & Groups/users
>You will see that there's an ASPNet user.
>
>Right click on the directory where your database is - choose properties -
>Then the sharing tab - then click on permissions.
>Add the ASPNet user to the shared section
>Then, make sure it has 'Change' rights -
>Click Apply and you should be working fine then.
>
>Source:
>
http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=111633