Avatar of dyarosh
dyarosh

asked on 

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?
Microsoft DevelopmentMicrosoft AccessMicrosoft ApplicationsMicrosoft Office

Avatar of undefined
Last Comment
dyarosh
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

That's part of the new Office 2007 Data Connectivity Drivers package

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
Avatar of dyarosh
dyarosh

ASKER

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?
ASKER CERTIFIED SOLUTION
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of dyarosh
dyarosh

ASKER

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

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.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo