how to access microsoft access db with no IDE, console and notepad only

[RickyWh]

How to access a microsoft access database using c# with a console application and no IDE?

[TheCPUWizard]

You can definately write a console based program that usilizes ADO.NET

Since you didnt ask any specific questions, that's abaout all there is to say....

[RickyWh]

Do you have a code example on how to go about doing so?

[TheCPUWizard]

Do you have a code example on how to go about doing so?

There is no magic... here is a SNIPPET.

DataSet ds = new DataSet();
ds.Fill(....);
DateTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows())
{
   Console.WriteLine(dr[0]);
}

That should give you enought parts to research.