[2005] Problem with SQL Update / Delete query

[maco]

Hi!

I'm using the following code to update my table, it reports no error but the data isnt being updated. I have no clue what I'm doing wrong here so all suggestions are in place.

'Open connection
            Dim DBPath As String
            DBPath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "/movies.mdb"
            cn = New OleDbConnection(DBPath)
            cn.Open()
 
 
            str = "UPDATE moviedata SET Length = '" & Length.Text & "', Actors = '" & Actor.Text & "', Description = '" & Descrip.Text & "', Rating = '" & Rating.SelectedItem & "', Genre = '" & Genre.SelectedItem & "', Location = '" & FileLocation.Text & "' WHERE Title='" & Title.Text & "';"
 
            cn.Close()
 
            MsgBox("OK")
 
        Catch ex As Exception
            MessageBox.Show(ex.ToString())
 
        End Try