Click here to Skip to main content
15,884,388 members
Please Sign up or sign in to vote.
1.57/5 (4 votes)
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

hey,

maybe its useful to use this constring:

C#
string conStr = "Provider=Microsoft.ACE.Oledb.14.0;Data Source=Database1.accdb; [Some Other Options=etc.;]";
for Office 2010
or this:
C#
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
 
Share this answer
 
 
Share this answer
 
Try using the jet engine.
http://www.connectionstrings.com/access[^]

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

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900