...

View Full Version : Help with MS Access Please



Cipher
10-24-2005, 01:42 PM
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

vinyl-junkie
10-24-2005, 03:58 PM
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.

Brandoe85
10-24-2005, 04:18 PM
In most cases it has to do with the permissions:
http://support.microsoft.com/default.aspx?scid=kb;en-us;316675

Good luck;

Cipher
10-24-2005, 04:23 PM
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.

Cipher
10-26-2005, 12:38 AM
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:

Brandoe85
10-26-2005, 12:49 AM
In most cases it has to do with the permissions:
http://support.microsoft.com/default.aspx?scid=kb;en-us;316675

Good luck;
Did you try this?

Cipher
10-26-2005, 02:59 AM
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 :(



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum