Man - you are a LIFE SAVER!! I was super frustrated by wanting to link a database with my VS project and so far no matter what I did I ran into problems. You think the engineers at Microsoft would look into these matters and issue an update (SP2 for instance) that fixed all these pesky problems. And SOLUTION #2 seemed only one that fixed this problem. That you very very much!
Solution number two helped me! once u have downloaded the file, try to close your application then open it again. and try to run ur program. surely it works!
Solution #2 worked for me, not solution #1. I greatly appreciate that you posted this information, it made my job much easier. I am writing a C# program using VS 2015 hitting an Access 2010 (accdb) database. I would not have thought of going backward to a 2007 download. Thanks again.
Thanks Mei Yi, I am using VS2013 Professional and MSOFFICE 2007. Got this message Access Violation!!! on NET Framework4. On NET Framework 3.5, I have the same message "Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" After I try your method, It works fine!!! thanks again.
Solution 2 worked like a charm. i couldn't get my application that i was testing out that i created years ago. i don't even have Visual Studio on PC lol. lots of thanks to you
Thank you. The second solution helped me. I was bothered by this for a long time. Can't understand how Microsoft would leave this "hole" in one of their products.
Hei Mei Yi I see you have help others. I do have the same problem. However I am running Office 2013 and Access 2013. I first installed the official version of the OLEDB.12.8. After that I installed Solution 2 as recommended with no luck.What to do? Regards Egil
if you still have a problem you need to check if your visual studio is 32bit or 64bit and use the right Microsoft Access Database Engine 2010 Redistributable that's was my problem. Thank you for the other information.
After Searching 15+ Websites On The Internet. It Was This Video That Helped Me To Get Connected To MS Access 2013 (ACCDB) Through VB .Net. Mei Yi Tan = KEEP UP THE GOOD JOB.
Thank you so much! This really helped me. I still had the same issues despite installing the database 2010 driver and solution 2 was all I really needed. I hope you have a blessed life and Godbless
Hi Sir! Uhm, I can see you really do help a lot of people by sharing your knowledge. I'm not here to ask you anything or what, I just wanna give you my sincere thanks for being so generous of what you know in these areas. So for helping a lot of people, I sincerely thank you Sir. Not all people are like you, so please keep it all up! Two thumbs up!
If you have already installed the Access Redistributable but still have problems, here is a remedy I discovered: (1) On the taskbar, click Windows and scroll down the installed app to 'Microsoft SQL Server YYYY' (where YYYY is the year) and click it. (2) A list of apps should appear underneath. One of them should be 'SQL Server YYYY Import and Export'. (3) Click that and the DTS Wizard runs. I was able to import data from Excel 365 without any problems. It appears that running the wizard outside of SSMS solves the problem. Regards.
Thanks!!! Solution 2 solved my problem :D! The issue was that I couldn't import some XLSX data into my database using SQL Server Management Studio 2014
OMG - You are a lifesaver! Now I don't have to smash my computer with a sledgehammer :). I do wish you continued on with the tutorial on connecting your database - as I am still having trouble after a successful connection ( As told by the wizard). The fields are still not populating and the program is throwing an exception saying that it is not a valid path. UGH!
if i have a project that was already done in win xp with vb 2010 and access 2010, can i open it in win 7 with your solutions ? or i have to rewrite all codes ?
i m using microsoft access 2007 and microsoft visual studio 2008 express edition... i m getting the error : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
![VS 2017 : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on Local machine. [SOLVED]](http://i.ytimg.com/vi/6WxyhuwgfAw/mqdefault.jpg)
Man - you are a LIFE SAVER!! I was super frustrated by wanting to link a database with my VS project and so far no matter what I did I ran into problems. You think the engineers at Microsoft would look into these matters and issue an update (SP2 for instance) that fixed all these pesky problems. And SOLUTION #2 seemed only one that fixed this problem. That you very very much!
32bit Visual Studio 2013 + 64bit Access 2013 here (on a 64bit Windows 8.1 system) and all I needed was the second solution to make it work. Thanks!
step 2 works for me. im using vs 2012 and ms office 2016. thank you so much . i love you man
The Solution 2 worked perfectly for me. Visual Studio 2015 and Access 2016. Thank you so much!
please sir,
please give me the backup's link
Solution number two helped me! once u have downloaded the file, try to close your application then open it again. and try to run ur program. surely it works!
Solution #2 worked for me, not solution #1. I greatly appreciate that you posted this information, it made my job much easier. I am writing a C# program using VS 2015 hitting an Access 2010 (accdb) database. I would not have thought of going backward to a 2007 download. Thanks again.
Thanks Mei Yi, I am using VS2013 Professional and MSOFFICE 2007. Got this message Access Violation!!! on NET Framework4. On NET Framework 3.5, I have the same message "Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" After I try your method, It works fine!!! thanks again.
autor of this video is THE best HUMAN on all planet
Solution 2 worked like a charm. i couldn't get my application that i was testing out that i created years ago. i don't even have Visual Studio on PC lol. lots of thanks to you
Thank you. The second solution helped me. I was bothered by this for a long time. Can't understand how Microsoft would leave this "hole" in one of their products.
The second worked for me on W10, VS2015, Office 2016... Thanks a lot!
Thanks, I am running VS Pro 2015 and Access 2016 and solution 2 worked fine!
LIFE SAVER Solution 2 worked for me even for 2016
Twizz Lordsi are you using 64bit?? cause ive tried installing 2016 engine and its not working :(
oww. nvmd IT WORKED!!!!
Hei Mei Yi
I see you have help others. I do have the same problem. However I am running Office 2013 and Access 2013. I first installed the official version of the OLEDB.12.8. After that I installed Solution 2 as recommended with no luck.What to do?
Regards Egil
Step two is totally working even im using 2016 access
Thank you teacher your video save me 2024❤❤
if you still have a problem you need to check if your visual studio is 32bit or 64bit and use the right Microsoft Access Database Engine 2010 Redistributable that's was my problem.
Thank you for the other information.
Thank you very much! And I think the key to this problem is to install the official Data Access Manager(Solution 2 or 3).
After Searching 15+ Websites On The Internet. It Was This Video That Helped Me To Get Connected To MS Access 2013 (ACCDB) Through VB .Net.
Mei Yi Tan = KEEP UP THE GOOD JOB.
OMG.... Thanks bro... its 2017 but it still working..... you have my like bro!
The 2nd solution worked perfectly! VS2013 + Office 2010. Thank you so much!
Windows 10 using VS 2012 and access 2013. Tried everything, but solution 1 worked!!
Thank you so much! This really helped me. I still had the same issues despite installing the database 2010 driver and solution 2 was all I really needed. I hope you have a blessed life and Godbless
Thank you , this problem occurs with the new MS Access also another solution is saving the access file as old access database
Hi Sir! Uhm, I can see you really do help a lot of people by sharing your knowledge. I'm not here to ask you anything or what, I just wanna give you my sincere thanks for being so generous of what you know in these areas. So for helping a lot of people, I sincerely thank you Sir. Not all people are like you, so please keep it all up! Two thumbs up!
🎉Thanks bro God bless you. Option 2 worked a charm.
2nd solution worked perfectly! i have VS2013 + Office 2010.soooooooo Thank you sooooo mach................
Thanks so much. I m using VS 2015 and Office 2016, solution 2 worked
Thanks!. Downloaded option2 and works with 2010 office
Good Job Sir u r the real MVP
Thanks Dude! You saved my time after lots of trail and errors..
Solution 2 was all we needed. Thanks a lot!
I had issue with importing excel data to sql server which has been solved by your solution 2.
Thanks for this video.
The 1st solution is enough to solve my concern. Thanks
Thanks heaps! Solution 2 worked for me on x64 Windows 7 running x64 Office. I used the direct download link provided. Cheers!
u just saved my time, God bless you
If you have already installed the Access Redistributable but still have problems, here is a remedy I discovered:
(1) On the taskbar, click Windows and scroll down the installed app to 'Microsoft SQL Server YYYY' (where YYYY is the year) and click it.
(2) A list of apps should appear underneath. One of them should be 'SQL Server YYYY Import and Export'.
(3) Click that and the DTS Wizard runs. I was able to import data from Excel 365 without any problems.
It appears that running the wizard outside of SSMS solves the problem.
Regards.
10000000000000000000000000 thanks ... first step and second for me ... windows 10 office 2013
Thanks!!! Solution 2 solved my problem :D! The issue was that I couldn't import some XLSX data into my database using SQL Server Management Studio 2014
2nd solution worked perfectly! i have VS2013 + Office 2010. Thank you!
OMG - You are a lifesaver! Now I don't have to smash my computer with a sledgehammer :). I do wish you continued on with the tutorial on connecting your database - as I am still having trouble after a successful connection ( As told by the wizard). The fields are still not populating and the program is throwing an exception saying that it is not a valid path. UGH!
it worked thank you very mach you get anew sbscriber .................guys use the thired option it worked for me
Second solution worked great for me, I have Visual Studio 2013 + Office 2013. Thanks a lot :)
Solution 2 worked perfectly with my asp.net mvc project, thanks for the tip
A segunda opção que consegui realizar a correção. Muito Obrigado a equipe por sempre esta passando informações simples para soluções extraordinárias.
a big thankyou, your video help me to over come a big problem
Thanks so much. I install VS 2012 and Office 2013, solution 2 worked.
The second option helped me out. thanks alot. 2007 office system driver data connectivity components 64 bit download
SOLUTION 1 & 2 WORK PERFECTLY SO VERY THANK YOU
I am using vs2010 and office 2013 .. do I need to download 2007 office system driver:DataConnectivity components?
Thanks! Second solution works for me.(VS 2010 Vs Office 2013).
Great !
Proprio quello che cercavo!
Grazie
Thanks. Solution 2 worked for me with VS 2013 + MSO 2010. Now 'Microsoft.ACE.OLEDB.12.0' is showing up. But I am getting unrecognised database error.
+Arulanand Antonysamy
Exactly, This happend with me also
Thanks Man.. Option 3 worked for me..
Solution 2 works for me, Thanks a lot!
Second solution worked for me as well (Visual Studio 2013 + MS Office 2013)
Thank you very much! The second method worked!
THank you very much!!! Second solution solved the problem.
It's work for me.. I use the firts solution .. thanks
I have Office 365 64-bit and Visual Studios 2019 on my 64-bit operating system. Non of the solutions work for me. Any help
Thanks! combo of Solution 1 and 2 worked for me
Thank you very much. Second option works brilliantly!
Dear friends follow 2nd solution for fast results.
2nd solution works perfectly. Thanks.
Solution 2 work for me too thank you very much
does it work in visual basic 2008 ?
Thank you! Second solution in combination with the first is working great!
1 and 2 worked for VS15 and Ms Office 2016
Thank you very much. I use office x32bit, but I build the program with x64. It has a problem. I follow the Solution 1. It works successfully. :D
Thanks for the solution!! Solution 2 works for me.
Thanks a lot! it works.. the 1st and 2nd only are enough for me. Nice one!
Hello friend thank you helped me even though I am a Brazilian I could follow their steps required .
Very helpfull
Lots of thanks
La opción numero 2 me resulto! Muchas gracias
if i have a project that was already done in win xp with vb 2010 and access 2010, can i open it in win 7 with your solutions ? or i have to rewrite all codes ?
Thanks dude your a life saver
life saved liked and commented Thumbs up
solution 2 just work fine for me thanks alot bro.
Thank you! Solution 2 works!!!
solution 2 worked for me...thnx a lot
Thanks, solution 2 worked for me.
thank you , this fixed my problem
Thanks for This Video
Your First Method is Working for me
i've try 3 solutions but it's still not work for me... im using windows 10, vs 2008, and office 2010. thanks for any help
i m using microsoft access 2007 and microsoft visual studio 2008 express edition... i m getting the error : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Me too im getting error Help us we already tried installing this fix!
2nd solution worked. thank you! GOD BLESS YOU
Thank You!! second solution worked for me!
can you help me , how if im using office 2016 MSA-ccess DB and ASP.net ?
Life saving video, thanks man
Thank you very much. Solution 2 worked for me.
Thank you everybody guys :)
Thank you so much second solution is working !
excelente y trabajando, perfect working I use option 2 and 3
Thank you, very USEFUL. I used the second solution and worked for me!!
second solution works.. thank u so much
2nd solution worked. thank you!
Grazie e Complimenti per questo video veramente utile!
thx mate, solution no 2 working for me
Is 2007 Office System Driver is Applicable for 2013?
Yes, absolutely.
yes, it works! thank you!
Thank you. You helped me a lot.