Help with MS Access Please
 

I'm having strange problem, when i try to read from Access it works so normal, but when i try to add any values it gives me this error:
Operation must use an updateable query.
I'm using ExecuteNonQuery

You are supposed to use ExecuteNonQuery when executing any SQL statement that does not return a set of results, such as INSERT, UPDATE and DELETE. Is that what you're trying to do? If not, you might want to post your code.

In most cases it has to do with the permissions:
http://support.microsoft.com/default...b;en-us;316675

Good luck;

I user alot of queries and all of them show me that error but here's the simplest one i use:

Dim UpdateSql As String = "UPDATE Threads SET Views = (Views + 1) WHERE ThreadID = " & ThreadID & ""
Dim UpdateCmd As New OleDbCommand(UpdateSql, Conn)
Conn.Open()
UpdateCmd.ExecuteNonQuery()
Conn.Close()

all other queries i user parameters, dont know if that may affect any or no.

People i really need HELP, i have a project with MS Access should deliver in 2days, please some ont try it and tell me!!! :confused:

Did you try this?

its a bloody probelm, and that page doesnt realy help, coz i tried the first solution and the page didnt want to work, and other 2 solutions cant work on them, cant find what they say :(