Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 7 of 7
  1. #1
    Regular Coder Cipher's Avatar
    Join Date
    Dec 2004
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Angry 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
    i need a creative atmosphere

  • #2
    $object->toCD-R(LP); vinyl-junkie's Avatar
    Join Date
    Jun 2003
    Posts
    3,096
    Thanks
    2
    Thanked 23 Times in 23 Posts
    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.
    Music Around The World - Collecting tips, trade
    and want lists, album reviews, & more
    SNAP to it!

  • #3
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    In most cases it has to do with the permissions:
    http://support.microsoft.com/default...b;en-us;316675

    Good luck;

  • #4
    Regular Coder Cipher's Avatar
    Join Date
    Dec 2004
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    i need a creative atmosphere

  • #5
    Regular Coder Cipher's Avatar
    Join Date
    Dec 2004
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts
    People i really need HELP, i have a project with MS Access should deliver in 2days, please some ont try it and tell me!!!
    i need a creative atmosphere

  • #6
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    Quote Originally Posted by Brandoe85
    In most cases it has to do with the permissions:
    http://support.microsoft.com/default...b;en-us;316675

    Good luck;
    Did you try this?

  • #7
    Regular Coder Cipher's Avatar
    Join Date
    Dec 2004
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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
    i need a creative atmosphere


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •