Click here to Skip to main content
14,579,890 members
Rate this:
Please Sign up or sign in to vote.
See more:
I used "provider=Microsoft.ACE.Oledb.12.0;Data Source= Database1.accdb" to connect from VB.net to Access 2010 but it doesn't work on 2013. Please tell me how ???
Posted
Updated 24-May-17 4:33am
Rate this:
Please Sign up or sign in to vote.

Solution 4

hey,

maybe its useful to use this constring:

string conStr = "Provider=Microsoft.ACE.Oledb.14.0;Data Source=Database1.accdb; [Some Other Options=etc.;]";
for Office 2010
or this:
string conStr = "Provider=Microsoft.ACE.Oledb.15.0;Data Source=Database1.accdb; [Some Other Options=etc.;]";
for Office 2013

i know that its could happen if you use windows 7 (64 bit) and office 2010 (for example),
that you need to install the "2010 office system driver data connectivity components" (<-google for it - 32 or 64 bit available) too.

but i didn't find actually such "office components" for 2013, so perhaps the "old" 2010 components works also on 2013.
by the way, as far as i know the JET-engine is no more supported since/for office 2007 ;)

greetz, me
   
Rate this:
Please Sign up or sign in to vote.

Solution 2

Try using the jet engine.
http://www.connectionstrings.com/access[^]

For future reference bookmark this: http://www.connectionstrings.com/[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100