By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,136 Members | 730 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,136 IT Pros & Developers. It's quick & easy.

update records in access db..

vikas1111
100+
P: 122
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???
Feb 23 '08 #1
Share this Question
Share on Google+
2 Replies

vikas1111
100+
P: 122
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
Feb 23 '08 #2

lotus18
100+
P: 866
Refer to this thread

.
Feb 23 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.