Why doesn't the database update?

[KB04]

Ok, I'm using ASP.NET with Microsoft Access 2000, I use the OLEDataAdapter to make a dataconnection to my .mdb database using Microsoft Jet 4.0 (or something like that). I can read from the database but when I fill the database into a dataset, change the dataset, then use the update comand in the dataadaptor it doesn't come up with any errors, it just doesn't update the database. Am i doing anything wrong?

Dim dat As New DataSet
        adapt.Fill(dat)
        Dim ar(2)
        ar(0) = TextBox1.Text
        ar(1) = TextBox2.Text
        ar(2) = TextBox3.Text
        dat.Tables("Pass").NewRow().ItemArray = ar
        dat.AcceptChanges()
        adapt.Update(dat)

I've tried lots of different methods, I've told the connection to open and close, I've updated the database with datarows and a datatable instead of a whole dataset, so far nothing seems to ahve worked, it just won't save, I don'tknow why and i was wondering if anybody knew whether somnething had gone wrong in my code, I used a wizard to create the update, insert and delete SQl statements so maybe it is something wrong with those.

KB04

[wey97]

Ok, I'm using ASP.NET with Microsoft Access 2000, I use the OLEDataAdapter to make a dataconnection to my .mdb database using Microsoft Jet 4.0 (or something like that). I can read from the database but when I fill the database into a dataset, change the dataset, then use the update comand in the dataadaptor it doesn't come up with any errors, it just doesn't update the database. Am i doing anything wrong?

Dim dat As New DataSet
        adapt.Fill(dat)
        Dim ar(2)
        ar(0) = TextBox1.Text
        ar(1) = TextBox2.Text
        ar(2) = TextBox3.Text
        dat.Tables("Pass").NewRow().ItemArray = ar
        dat.AcceptChanges()
        adapt.Update(dat)

I've tried lots of different methods, I've told the connection to open and close, I've updated the database with datarows and a datatable instead of a whole dataset, so far nothing seems to ahve worked, it just won't save, I don'tknow why and i was wondering if anybody knew whether somnething had gone wrong in my code, I used a wizard to create the update, insert and delete SQl statements so maybe it is something wrong with those.

KB04

I think you have the last two lines backwards. Try:

adapt.Update(dat)
dat.AcceptChanges()