I am unable to get beyond this error when trying to add a Microsoft Access database (.accdb) as a data source in Visual Studio 2019. I’ve tried to add this data source to a Visual Basic and C# program with the same results. I’ve followed guidance I’ve found on the Internet and added the 2010, 2013, and 2016 Access database engines all with the same result. I’ve changed the TargetCPU to AnyCPU, X86, and X64 all with the same result. I can add an Access .mdb database as a data source but not an .accdb and my application requires the later database format.
My system is running Windows 10 x64 with Office 365 and Visual Studio 2019 all with the latest updates.
Disclaimer: I am a hobbyist programmer and this application is for a single user (me) and I prefer to use Access because I have it as part of Office 365 and it is easy to create and view dataset objects and their content. Many do not like Access and that’s understandable in a business multi-user environment. Many also prefer other languages like Python but I will stick with Visual Basic (or possibly Micro Focus COBOL) for personal reasons. Lastly, my request for help is not an invitation to you to try to sell me your curriculum (as experienced on Facebook).


