I recently built a package with Developer to deploy MDAC 2.7 SP1. I'm using the MDAC27ENU.MSM which I downloaded from Installshield. I created a new project and merged the MDAC module into it. Then, I created a transform to run the install silently:
I've been able to suppress the Add/Remove Programs Icon as well as the automatic reboot. The installation is completely silent with one exception: The Microsoft Data Access Components window displays as the files are being extracted, and presents the user with a Cancel button. It seems like this window is being generated as part of the merged component, and I'd really love to get rid of it (or at least disable the Cancel and Close buttons). If the user cancels during the extraction process, the OS seems to be fooled into thinking that the package was installed, and everything goes down hill from there.