Connect to .accdb instead of .mdb Access database

We sometimes face issues while connecting to .accdb Access Database instead of .mdb Access Database.

For this, we use different Provider while declaring our Connection String.

string connectionString = @”Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\DailyExpenses.mdb“;

For .mdb, we use Microsoft.Jet.OLEDB.4.0 Provider.

For .accdb, we use Microsoft.ACE.OLEDB.12.0 Provider.