OLEDB error. "Operation must use an updatable query."

At one time I published a web project that used OLEDB to connect to Ms Access and update some data I got an error "Operation must use an updatable query."

Some googling reached me on this site: “Operation must use an updateable query” error in MS Access

The chosen as answer doesn't really solve my problem. but the second answer really solve it.

The Answer:

There is no error in the code, but the error is thrown due to the following:

 - Please check whether you have given Read-write permission to MS-Access database file.
 - The Database file where it is stored (say in Folder1) is read-only..? 

suppose you are stored the database (MS-Access file) in read only folder, while running your application the connection is not force-fully opened. Hence change the file permission / its containing folder permission like in C:\Program files all most all c drive files been set read-only so changing this permission solves this Problem.

So I change the permission on my folder (App_Data) that stored my Ms Access database to full control.

Problem solved.




PS: I made a bat file for changing permission of "App_Data" folder to "Everyone" with Full Control. Just put it side by side with the "App_data" folder.

permission.bat