VS2008 Manual Procedure for Access Database

[ddclondon]

Can someone please help with the following:

I would like to manually access and update an Access Database without using bound user interface objects

For example:

1) Open the Database (eg: AJAXMAIN.ACCDB)
2) Create a Dataset of one of the tables in the database (eg: Contacts)
3) Loop through all records in that table and edit one of the fields
4) Update the table while completing the edit of each record.

While the code for doing this in VB6 is eazy peazy the code for doing it in VB2008 escapes me at present so any help would be much appreciated.

[si_the_geek]

I recommend you take a look at the "ADO.Net" section of our Database Development FAQs/Tutorials (at the top of the Database Development forum), particularly the ADO.Net Tutorial.