how to connect with ms assess

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


If adoAccessReader.HasRows Then
'Do Stuff
End If


If oAccessConn.State = ConnectionState.Open Then
End If

how to connect with ms assess