Operation must use an updateable query.
I tried updating/writing to a table in MS ACCESS database from an ASP.NET application and i recieved the above error.Which means i can't update or insert to my database file and it didn't have the "WRITE" permission.So i decided to add this PERMISSION to my MS ACCESS file.
I use WIN XP and i discovered that by right clicking the folder where my MC ACCESS DATABASE FILE is i didn't see the the SECURITY options in the TAB options and either through the properties options.But on my WIN 2000 server i had this option.
So after some research i came across this article "Howto configure file sharing in Windows XP" at :- http://support.microsoft.com/default.aspx?scid=kb;EN-US;q304040.
- So my solution was that I opened up Windows Explorer selected the tools menu > Folder Options and select View tab then uncheck "Use simple file sharing".
- After that go back to the folder where the file exist and after right clicking you will see the options "SECURITY" and then you give the FOLDER the right permissions.
And that solved my probs...
Enjoy .NETTING!