Has anybody automated the MS Access 2007 using MS-DOS batch file? I had ran the batch file and the windows installer message appeared with the following message: The upgrade patch cannot be installed by the Windows service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program." Which patch is it referring to? Please provide some feedback. Thank you
0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


perhaps a little less detail would help..

try posting the batch file.
Answered 09/23/2011 by: jmcfadyen
Fifth Degree Black Belt

Please log in to comment
Here is the batch file:

"\\%server%\Apps\5 DMCN Templates\LogFile.vbs"
if exist "%LogFolder%\%AppName%.log" goto :%AppName%
"\\%server%\Apps\MSAccess 2007\Access2007.MSP"
echo " " > %LogFolder%\%AppName%.log
"\\%server%\apps\5 DMCN Templates\license.vbs"

Thank you
Answered 09/26/2011 by: DaveX
Yellow Belt

Please log in to comment
Can I suggest, before you do anything else, that you apprise yourself of the fundamentals of Windows Installer, one of which is that MSPs are non-executable?

You can then subsequently discover, to your delight, that Microsoft has decided that patches are to replace transforms AND that its products are no longer installable by executing MSIs/MSTs but instead by running the set-up executable. Having created your MSP (I presume that 'Access2007.MSP' is one you've created using the set-up execuatble?) you need to deposit it in the 'Updates' folder and use the set-up executable and the various shaking-of-bones arguments (e.g. /adminfile) which are now being used.

Look up the 'Package KB' for MS Office 2007 or 2010. It's pretty well documented therein.
Answered 09/26/2011 by: VBScab
Red Belt

Please log in to comment