Hi Peeps,

I have the following code:-

Code:
        sSQL = "SELECT * FROM FILESTRUCTURE"
        oleDAFiles = New OleDb.OleDbDataAdapter
        oleDAFiles.SelectCommand = New OleDb.OleDbCommand(sSQL, oleDCData)
        oleDSFiles = New DataSet
        oleDAFiles.Fill(oleDSFiles, "FILESTRUCTURE")

        For iRowCount = 0 To oleDSFiles.Tables(0).Rows.Count - 1
            oleDSFiles.Tables(0).Rows(iRowCount).Delete()
            oleCBFiles = New OleDb.OleDbCommandBuilder(oleDAFiles)
            oleDAFiles.Update(oleDSFiles, "FILESTRUCTURE")
        Next
On the update I get a syntax error and do not no why?????

Thanks for any help,

Jiggy!