Manually coding a connection to MS Access.

I am writing an application that retrieves and updates data
in an MS Access Database.
I do not want to use the data wizard or drag the components
onto the designer and use the wizards because I must use a variety
of SQL statements to retrieve specific information from the same table.

I have Microsoft Visual Studio.Net 2003 installed on my laptop.
When I try to declare a connection as New OleDbConnection() it says that
OleDbConnection is undefined.

I do not understand this.
Could someone please give me the steps from start to finish on how to connect in code, create
the dataset, data tables, etc. and access the records in the database tables.

I'm confused.
-Newbie

Check this one......

http://216.239.57.104/search?q=cach...Apr2003/003.asp

Good Reference:

ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/cpguide/html/cpconaccessingdatawithadonet.htm

try importing --> System.Data.OleDb
It's where OleDBConnection() is defined.