hi am trying to insert a data into access database with vb.net interface (2005)the porplem is the adding is completed succeful in the dataset only not in the real database this is the code **** Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\Nwind.mdb") Dim sql As String = String.Empty sql = "INSERT INTO Categories (CategoryID,CategoryName,Description)" & "values('" & txtid.Text & "','" & txtname.Text & "','" & txtdes.Text & "')" conn.Open() Dim command As New OleDb.OleDbCommand(sql, conn) command.ExecuteNonQuery() conn.Close()*********what's UP ?