OleDb connection to Access 2013 database

Asked Nov 05 '13 at 16:58

Active Nov 05 '13 at 19:21

Viewed 1,694 times

I have a program that reads from and writes to an Access database. It works fine on my own computer but when I tried to download it on a new computer that has the new Office 2013 programs it said that the provider in connection string didn't work. Here's my connection string:

string filepath = @"C:\FamilyFoundations\ProvidentLiving\App\Data\"; // Hold the path to the file
string dbPath = filepath + "GoalsDB.accdb"; // Holds the name of our data base

// string to create our database
string db = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + dbPath + "; JET OLEDB:Engine Type=5";'

Does my string need to be changed or is there something I need to download on my friends computer? My first thought is that there is a new Microsoft.JET that I need to include, but please correct me if I'm wrong.

edited Nov 05 '13 at 19:21

Gord Thompson

116,920
32
215
418

asked Nov 05 '13 at 16:58

Morgan Willis

Is your project targeted to the 32-bit ("x86") platform as described in the answer [here](http://stackoverflow.com/a/19686200/2144390)? – Gord Thompson Nov 05 '13 at 18:08
Thank you for your response. It's target platform is any CPU but prefers 32 bit – Morgan Willis Nov 05 '13 at 18:14
3

Well, you could try setting the target platform to *just* x86 and see if that helps. – Gord Thompson Nov 05 '13 at 18:47
@GordThompson Same error message. Do I need to download the .net file on his computer? – Morgan Willis Nov 05 '13 at 22:58
Which ".NET file" would that be? – Gord Thompson Nov 05 '13 at 23:04
Sorry I meant the framework. For example my program uses the .NET Framework 4.5. Do I need to download some sort of a converter file? – Morgan Willis Nov 06 '13 at 01:07

OleDb connection to Access 2013 database

0 Answers0