m using visual studio 2005 and access 07.
this is my code. ive also attached an access 07 file and this is the exact data tht my actual database has..plz help
Dim DataAdapter As New OleDb.OleDbDataAdapter("Select ID from Customer", oledbcon) Dim datatable As New DataTable DataAdapter.Fill(datatable) Dim CommandBuilder As New OleDb.OleDbCommandBuilder(DataAdapter) id = datatable.Rows(datatable.Rows.Count - 1)("ID")
the problem is id does not reflect the last value(i.e. 44) as it shud
it reflects 43.
how ever if i delete row with id 44 thn is works fine but as soon as i add row with id 44..problem strts plz help