Do I have to have this upgrade support to use DAO code?

Module UpgradeSupport
    Friend DAODBEngine_definst As New DAO.DBEngine()
End Module


Do I have to have this in my program to :

Dim Center_Database As DAO.Database
    Dim Main_TD As DAO.Recordset
    Dim MAIN_TD As DAO.Recordset
Floor = DAODBEngine_definst.OpenDatabase("\\tpserver1\inve ntory\13FloorEquipment.mdb")
 MAIN_TD = Floor.OpenRecordset(COmpare, DAO.RecordsetTypeEnum.dbOpenDynaset)

Ok, I was just informed that ADO is not supported in Vb.net, thus that is why recordset can not be opened with out using the upgrade.

Does anyone know how to loop thru records in an Access Database ?


Thank you

You need to look into the System.Data.Odbc namespace. You can use an OdbcConnection class to connect to an Access database. There are lots of threads in the wrox forums dealing with Access. Once you are connected, you can use an OdbcDataReader. This is really the simplest .net form of the former ADODB.Recordset. You can use a data reader to go thru the rows returned from your table/query. The datareader is a forward-only read-only collection of rows. You can use the a reader to loop or for databinding to a data listing control.

Peter
------------------------------------------------------
Work smarter, not harder.