[reinier]

Hi

I'm new to vb.net but have coded in VB6 for a few years.
My question is:
How do I connect to and query a access 2000 database ? I saw in the book that I have that you have to put object like the sqldataadapter on the screen. Is this the same as the dataconnection obkect that was in VB ? I usually coded my connection strings and all that and defined the record sets in code.
What is the correct way to do this in vb.Net ? Please help!!

Regards Reinier

[kasic]

I think this code should do the work

Imports System.Data.OLEDB
Imports System.Data

Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ure_db.mdb;"
Dim strSQL As String = "SELECT * FROM some_table;"
Dim conn As New OLEDB.OLEDBConnection(strConn)
conn.Open()

Dim cmd As New OLEDB.OLEDBCommand(strSQL,conn)
Dim DataR As OLEDB.OLEDBDataReader = cmd.ExecuteReader()

While (DataR.Read())
DataR.Item("field_from_some_table")
End While

this should work...