[RESOLVED] [2008] MDB not updating with da.update

[rhijaen]

I fixed it..had to be sql = "SELECT SetID, Filename, [Size] FROM Files ORDER BY SetID, Filename, [Size] DESC"

But now I get: No value given for one or more required parameters.

Why can't this just work?

        con.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & OpenFileDialog1.FileName
        con.Open()
        sql = "SELECT * FROM Files ORDER BY SetID, Filename, [Size] DESC"
        da = New OleDb.OleDbDataAdapter(sql, con)
        da.Fill(dt)
        con.Close()