I need help creating a connection to MS Access

Question

Here is my question: I have created an MS Access database and I am trying to create a connection using VB2005 Thanks J

Vijaya Kadiyala · Answer

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

Sriram Ramani · Answer

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

theo philus · Answer

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

I need help creating a connection to MS Access

Answers (3)