Several years ago I display Gridview data from AccessDataSource control from Access 2010 mdb file by installing Access 2010 Redistrbutable then fine.
However, now my PC runs on 64bit OS, Ms Access 2016. What runtime/redistributable install is needed ?
Then what is the connectionstring need in web.config ?
Then use sqldatasource control ?
I now get this error. I already installed 2010 redistributable
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Temporarily, I have to change it to Provider=Microsoft.Jet.OLEDB.4.0 in web.config. This enable me to run from VS loalhost successfully, but when I run it outside then it has problem when run outside VS.
Pls help
Thanks
Thanks. I will try to credit the ones who helped but most important is we really do sincerely thanks to all who have helped.
According to your description, as far as I know, you are lack of the component of the Access, here are someone who meet the same problem as you, please check:
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine:
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Participant
753 Points
2406 Posts
How to connect to 2016 Ms Access Database file ?
Mar 23, 2017 07:18 AM|hkbeer|LINK
Several years ago I display Gridview data from AccessDataSource control from Access 2010 mdb file by installing Access 2010 Redistrbutable then fine.
However, now my PC runs on 64bit OS, Ms Access 2016. What runtime/redistributable install is needed ?
Then what is the connectionstring need in web.config ?
Then use sqldatasource control ?
I now get this error. I already installed 2010 redistributable
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Temporarily, I have to change it to Provider=Microsoft.Jet.OLEDB.4.0 in web.config. This enable me to run from VS loalhost successfully, but when I run it outside then it has problem when run outside VS.
Pls help
Thanks
www.developerfusion.com/tools/convert/csharp-to-vb/
Contributor
6720 Points
2715 Posts
Re: How to connect to 2016 Ms Access Database file ?
Mar 24, 2017 02:03 AM|Eric Du|LINK
Hi hkbeer,
According to your description, as far as I know, you are lack of the component of the Access, here are someone who meet the same problem as you, please check:
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine:
http://stackoverflow.com/questions/6649363/microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine
the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine while reading a excel file in c# [duplicate]:
http://stackoverflow.com/questions/33384959/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine-w
Best Regards,
Eric Du
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.