Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Currently I am using Microsoft Visual Studio 2015 Community and I'm trying to read an access database. I have installed VS 2022 because it just came out. Not sure if this is bothering me??? Help!
AND I HAVE INSTALLED/FOLLOWED MICROSOFT'S INSTRUCTIONS!!! IT STILL DOES NOT WORK!!! HELP PLEASE!!!!

What I have tried:

Installing microsoft.ace.oledb.12.0, 14 and 16 has not helped.
I HAVE INSTALLED/FOLLOWED MICROSOFT'S INSTRUCTIONS!!!  IT STILL DOES NOT WORK!!!  HELP PLEASE!!!!
Posted
Updated 23-Dec-21 8:45am
v3
Comments
RedDk 23-Dec-21 19:44pm    
In addition to what OG says there's also TWO regsvr32 apps (one in System32 and one in WOW64) and you've got to pick the one which ... succeeds at registering the driver.

I managed to get Access 2020 installed on Windows 10 by doing the very thing you're having trouble with ... the wrong driver is named in your old code. Mine WAS "Provider=Microsoft.Jet.OLEDB.4.0;" and I had to change it to "Provider=Microsoft.ACE.OLEDB.16.0"

1 solution

Check your app properties: the ACE db engine comes in two varieties as well as a number of versions. If you app is configured as 64 bit, then you need to have the 64 bit ACE engine installed, and for a 32 bit app you need the 32 bit version. A process can't switch word sizes at run time, so you can't use 32 bit code from 64 or vice versa.

Then check your connection string and ensure that that matches the ACE version you have installed as well.
 
Share this answer
 

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


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