Operation must use an updateable query
Recently I have to reinstalled my WindowsXP Prof. and now my app. done in VS.NET 2003 wonât update itâs Access 2000 db. I changed the dbâs folder property (Web Sharing/Share this folder/Edit Properties/Check â Read & Write) but without effect.
There is another folderâs Read-Only attribute in the General tab but when I switch it off and go back to it, it still is on. Is this the problem? And if it is, why canât I turn it off?
I copy the db directly to the c: root and redirected the Connection String to it but no budge, everything works but update.
Following some ASP.NET Forums advice I went to Computer Manager/Local Users and Groups/Users, copy the âASP.NET Machine Accountâ, went to the dbâs folder/properties/Web Sharing, pasted the âASP.NET Machine Accountâ in the Aliases list, changed the Edit Properties to Read, Write and Execute (I try it all possible ways; âASP.NETâ, Read, Write, Script), and still no go.
Can you write me line by line how to go about it? (Novice)
Thanks a lot. Henry