Member Avatar for vpns.praveen

hi!
i m nu to VB
pl.explain how to connect
VB to Access data basic using ADO control,
if any other way, pl do help me.

than u.

  • 2 Contributors
  • 1 Reply
  • 83 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

select microsoft activex dataobject library 2.8 from the Project ---> reference menu

then try the following sample code

Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
Private Sub Form_Load()
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Debasis\Desktop\company.mdb;Persist Security Info=False"
rs.Open "select * from employee", con, adOpenDynamic, adLockOptimistic
End Sub
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.