Click here to Skip to main content
12,293,583 members (57,878 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB VB.NET
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 9-Jan-13 3:27am
Rate this: bad
 
good
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 Wink | ;)

greetz, me
  Permalink  
Rate this: bad
 
good
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/[^]
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160525.2 | Last Updated 28 Mar 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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