VB Code:
Dim Conn As OleDbConnection
Dim Cmd As OleDbCommand
Dim reader As OleDbDataReader
Conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\somePath\mydb.mdb;User Id=;Password=;")
Cmd = New OleDbCommand("SELECT fieldName FROM tableName", Conn)
Try
Conn.Open()
reader = Cmd.ExecuteReader()
While (reader.Read())
Response.Write(Convert.ToString(reader("fieldName")) & "<br>")
End While
reader.Close()
Conn.Close()
Catch ex As Exception
Response.Write("Error Occurred: " & ex.Message)
End Try