How do I Connect to, and reading from Access

I have searched and found a fair few pages but they all relate to VS 2005 and VS 2008 only.

What I need to do, using VS 2010, is connect to an Access 2000 (mdb) database.

I then need to access a table called "technicians" that has about 30 fields, but I am only interested in 2 of them - "name" and "isdisabled".

What I want to do is populate an array using the values from "name" if "isdisabled" is set to "0"

Can anyone give me some instructions or point me in the direction of a VB 2010 tutorial?

Thank you.

download my book it has a walkthrough about mining data in an access database

I don't think anything has changed regarding accessing an Access Database between 2005, 2008, and 2010. Those tutorials should still work for you. You can also check out this site:

http://www.homeandlearn.co.uk/NET/nets12p1.html

There are various ways to work with databases in .NET. You can use raw ADO.NET, a typed DataSet or the Entity Framework, just to name those available for Access out of the box. I'd probably suggest starting with a typed DataSet.

To that end, you might like to folllow the Data Walkthroughs link in my signature, which includes one on using Access. That Home & Learn tutorial also uses a typed DataSet, if I'm not mistaken.