Member Avatar for amarnatheee

how to connect vb.net with ms assess

  • 2 Contributors
  • 1 Reply
  • 95 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by paulie
Member Avatar for paulie

Easy. Import System.Data.OLEDB, then connect with this code:


Dim sAccessConn AsString = "
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Northwind.mdb;Jet OLEDBDatabase Password=YourPasswordIfNeeded"

Dim oAccessConn As OleDbConnection = New OleDbConnection(sAccessConn)

Dim cmdAccess As New OleDbCommand("Select * from Whatever", oAccessConn)

Dim adoAccessReader As OleDbDataReader = cmdAccess.ExecuteReader

adoAccessReader.Read()

If adoAccessReader.HasRows Then
'Do Stuff
End If

adoAccessReader.Close()

If oAccessConn.State = ConnectionState.Open Then
oAccessConn.Close()
End If

how to connect vb.net with ms assess

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.