I need help creating a connection to MS Access

Hi Check out the below link

http://www.astahost.com/info.php/vb-net-ms-access-interaction-tutorial-part_t12054.html

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com

All u need is first select add new database and select the MS.Access database and load ur file and table..

then u must add a connection

first include the "import system.data.oledb" namespace....

then include this code:

Dim a As String

Public cn As OleDbConnection

Public cmd As OleDbCommand

Public dr As OleDbDataReader

Public Sub conn()

a = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Bday pro database\bday.accdb" ---"bday" name of ur file

cn = New OleDbConnection(a)

cn.Open()

End Sub

Julius you can try the following codes using c#.net

OleDbConnection conn=new OleDbConnection(@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\students.mdb");
conn.Open();
OleDbCommand cmd=new OleDbCommand();
conn.Connection=conn;
conn.CommandText=String.Format("Select * from Students");
OleDbDataAdapter adp=new OleDbDataAdapter(cmd);
int temp=cmd.ExecuteNonQuery();
if(temp>0)
{
  MessageBox.Show("Records Selected");
}
else
{
 MessageBox.Show("Records Not Selected");
}

From SIAMEH THEOPHILUS UNIVERSITY OF GHANA,LEGON-----00233 243559227