How do I include 2007 Office System Driver: Data Connectivity Components as a prerequisite in my installation project
I have a Windows Forms application that uses a MS Access 2007 database. I've created the installer using Visual Studio. When I install the program on a machine that does not have MS Access, I get the following error:
The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.
How can I add this as a prerequisite to my installation and have it install if it is not on the machine?
I knew where to get the Office 2007 Data Connectivity Drivers package. I don't know how to create the installer to install it if needed. Can you help me with that?
Thanks for your help. This at least explains things better so I can add the Microsoft.ACE.OLEDB.12.0 to my project.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
I suspect you could write a custom install launch condition that automatically installed this if needed
Solution from graye, found at: https://www.experts-exchange.com/questions/23608221/Adding-Microsoft-ACE-OLEDB-12-0-provider-to-deployment-project.html?anchorAnswerId=22122885#a22122885