update records in access db..

[vikas1111]

Hi All..
I want to access records from access database and edit them and save the changes using visual basic.. How can i do that ???
Can anyone please help me???

[vikas1111]

Hi All..
I want to access records from access database and edit them and save the changes using visual basic.. How can i do that ???
Can anyone please help me???

This is the code which i have written

Private Sub Form_Load()

Dim RSNew As New ADODB.Recordset
Dim RSNew1 As New ADODB.Recordset
c.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:/Comion.mdb;Persist Security Info=false")

rs.Open "select * from setting", c, adOpenDynamic
Me.Text1.Text = rs(2)
Me.Text2.Text = rs(3)
cs = Text1.Text
rs.settings(rs(2)) = cs
rs.Update
If Not rs.EOF Then rs.MoveNext
rs.Close
End Sub

[lotus18]

Refer to this thread

.