using System;
using System.Data.OleDb;
 
class OleDbTest{
 
public static void Main()
{
//create the database connection
OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\\Initiatives4.mdb");
 
//create the command object and store the sql query
OleDbCommand aCommand = new OleDbCommand("select * from tbl_users", aConnection);
try
	{
		aConnection.Open();
 
		//create the datareader object to connect to table
		OleDbDataReader aReader = aCommand.ExecuteReader();
		Console.WriteLine("This is the returned data from emp_test table");
 
		//Iterate throuth the database
		while(aReader.Read())
		{
			Console.WriteLine(aReader.GetInt32(0).ToString());
		}
 
		//close the reader 
		aReader.Close();
 
		//close the connection Its important.
		aConnection.Close();
	}
 
	//Some usual exception handling
	catch(OleDbException e)
	{
		Console.WriteLine("Error: {0}", e.Errors[0].Message);
	}
	}
}

Exception System.Security.SecurityException was thrown in debuggee:
Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
 
OpenConnection()
Open()
Main() - \\boffil01.group.net\lv14942\SharpDevelop Projects\textconn\Program.cs:17,3

//OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\\Initiatives4.mdb");
 
//OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\\Initiatives4.mdb;Jet OLEDB:System Database=system.mdw;");
 
//OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\\Initiatives4.mdb;Jet OLEDB:System Database=system.mdw;Trusted_Connection=yes");
 
OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\\Initiatives4.mdb;Jet OLEDB:System Database=system.mdw;Trusted=yes");

    public static string BuildAccessConnectionString(string Filename, string Username, string Password, string DatabasePassword)
    {
      return string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='{0}';User Id={1};Password={2};Jet OLEDB:Database Password={3};",
                                   Filename.Replace("'", "''"),
                                   Username,
                                   Password,
                                   DatabasePassword);
    }

string connStr = BuildAccessConnectionString(@"H:\Initiatives4.mdb", string.Empty, string.Empty, string.Empty);

Argument '2': cannot convert from 'string' to 'System.Data.OleDb.OleDbConnection'
 
The best overloaded method match for 'System.Data.OleDb.OleDbCommand.OleDbCommand(string, System.Data.OleDb.OleDbConnection)' has some invalid arguments 
 
'string' does not contain a definition for 'Open' 
 
'string' does not contain a definition for 'Close'