MS Access connection with C# windows project

If you look at the Server Explorer pane in visual studio, then click on your database, the connection string will be listed in the Properties pane.
Copy this, and paste it as the connection string in place of "Microsoft.VisualBasic.VBCodeProvider" in your code above.

Hi,

Have a look at Different ways of ConnectionStrings:

For Access[^]
For Access 2007[^]

P.S: Please check connecting properly.

There is another question related to this:
Connection string in C#.net[^]

I hope this one helps.

OleDbConnection dbconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename_with_Location + ";Jet OLEDB:Database Password=****;");
OleDbDataAdapter dAd = new OleDbDataAdapter("SELECT * FROM table", dbconn);
                DataTable dt = new DataTable();
                dAd.Fill(dt);

Hope this can help you.