Operation must use an updateable query

I had created a windows application.

The application will pull data and insert to an access database.

But while running the application half way through, it will gives me the above error message "Operation must use an updateable query"

I had read through some of the forum, most of them mentioned that it is due to permission settings and they are using asp.

But I had check my table permission. It is read and write. Moreover , I am running as an application.

Can anyone please help



Answer this question

Operation must use an updateable query

  • voss

    If am ask what the query script youre are trying to execute

    this error may likely to be caused by repetition of data in your table.



  • Frank Gervais

    How do you call your insertquery

    Show some relevant code of how you do the insert, and on which line the exception occurs.



  • Operation must use an updateable query