Here are some tutorials that i gathered from net. Some are as old as 5 years but all of them are great.So read them and learn from them use your brains and things will work for you.

 

List of tutorials that can help you :

You can download the sample Zip file and try it. Coder stats that he wrote a code to abstract the dbase access for C++ using its COM object. It will be better to read the info file before trying it, the link is here.

 

To connect MS Access 2010 VIA C#

In case if you are using Jet Engine 4

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

To edit using C#

Here is the example code

private void Window_Loaded(object sender, RoutedEventArgs e)
    {
 
    }
 
    private void button3_Click(object sender, RoutedEventArgs e)
    {
 
        OleDbCommand cmd = new OleDbCommand("INSERT INTO tbl_Fullname (Lastname,Firstname,Middlename) VALUES (@first,@last,@midn)",conn);
 
        conn.Open();
        cmd.Parameters.Add("@first", OleDbType.VarChar).Value = textBox1.Text;
        cmd.Parameters.Add("@last", OleDbType.VarChar).Value = textBox2.Text;
        cmd.Parameters.Add("@midn", OleDbType.VarChar).Value = textBox3.Text;
        cmd.ExecuteNonQuery();
        conn.Close();
    }
 
    private void textBox4_TextChanged(object sender, TextChangedEventArgs e)
    {
        conn.Open();
        OleDbCommand cmd2 = new OleDbCommand("SELECT fnID,Lastname,Firstname,Middlename FROM tbl_Fullname WHERE fnID= @id", conn);
 
 
        cmd2.Parameters.Add("@id", OleDbType.VarChar).Value = textBox4.Text;
        try
        {
            OleDbDataReader dr = cmd2.ExecuteReader();
            if (dr.Read())
            {
                textBox1.Text = dr[1].ToString();
                textBox2.Text = dr[2].ToString();
                textBox3.Text = dr[3].ToString();
                textBox5.Text = dr[0].ToString();
 
            }
            else
            {
                MessageBox.Show("No result");
            }
 
        }
        catch (Exception ex)
        {
 
 
            MessageBox.Show(ex.Message);
        }
        conn.Close();
 
    }
 
    private void button1_Click(object sender, RoutedEventArgs e)
    {
        conn.Open();
        OleDbCommand cmd = new OleDbCommand("UPDATE tbl_Fullname SET Firstname=@firstn,Lastname=@lastn,Middlename=@midn WHERE fnID=@idn", conn);
 
        cmd.Parameters.Add("@idn", OleDbType.VarChar).Value = textBox5.Text;
        cmd.Parameters.Add("@firstn", OleDbType.VarChar).Value = textBox1.Text;
        cmd.Parameters.Add("@lastn", OleDbType.VarChar).Value = textBox2.Text;
        cmd.Parameters.Add("@midn", OleDbType.VarChar).Value = textBox3.Text;
        cmd.ExecuteNonQuery();
        conn.Close();
    }
}

 

If you want to know how to connect Ms access and Visual C++ (2008). Follow the link to read step by step method.

Microsoft Access database table from VC++