Click here to Skip to main content
12,819,619 members (34,067 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 4:27am
Updated 1-Jul-16 19:13pm
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 ;)

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  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 5

I Already do that still, having same problem on the other hand i use access engine 12.0 redistributable but still it is not working
  Permalink  
Comments
Richard MacCutchan 2-Jul-16 3:41am
   
This is not an answer. If you have a problem then please post a new question, and ensure you include full details of the problem.

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.170308.1 | Last Updated 2 Jul 2016
Copyright © CodeProject, 1999-2017
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