install failure of deployment package
I have an .mdb with several Activex controls (Date Time Picker, MS Common Dialog controls ) and other references (to the Word Object model, of course VBA and DAO)associated with it. The file runs FINE on the machines I finished development on (both XP machines which have Office 2K Development Edition) but the deployment package does not install on my machine at work (running Windows 2K, a regular A2K license and no Visual Studio). It goes into install, and when it gets to "installing MSVM60.dll ("7 of 7)" a msgbox says it has to re-start the System. Once re-started, installation does not resume, and the package does NOT complete installation. When you begin install again it runs through the same confirmation screens, and repeats its performance when "installing MSVM60.dll" comes back up.
msvm60.dll is already on my machine. Deleting it, then running Install for the deployment package confirms the package is installing that .dll. Our Tech tried installing the upgrade for msvm60.dll, and that did not solve the problem.
I tried making a NEW deployment package with just a form, table with dummy data and the 2 Activex controls needed, and that installed fine onto the machine. The Date Timepicker works fine WITHIN that one .mdb, but does not allow itself to be used in other .mdbs on the machine. So that "work-around" doesn;t solve it.
1. Does anyone have any suggestions as to what may be going wrong (and how to fix it?)
The next step in the "experiment" is to install XP, but it's a big job that (if possible) we'd prefer to avoid.
2. Do Activex controls register to an individual .mdb? If so, is there a way to "hand register" them? (Or is there another piece of the control that is only available for development?) I was hoping I could use those Activex's in other .mdbs once they were on my machine.
Our final installation is for 2 or 3 machines to use the .mdb, which we'll put on a Share on the server. I'll split the db and we'll put a FE on each machine (with the Activex's) on each machine after I confirm it's working and the forms fit the screens.