I have been trying to install Access Runtime 2007 as part of a clickonce installation by creatinga prerequisite. This worked fine with Access Runtime 2003 but with 2007 the install seems to 'hang'. It downloads the file and starts the installation but doesn't progress. I think it is waiting for the user to agree to the eula BUT the EULA doesn't appear. Ideas?

Hi SmartFX,

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi Bruce

More updates. I have now discovered that the install works if I use the "/passive" switch as this stops the installation package from showing the EULA. This doesn't really make sense to me but it works so all good really.

For anyone else who is interested I have pasted the product.xml file below.
The only thing left now is if anyone could give me a Microsoft URL to use as the 'HOMESITE' so we dont have to host the installation package on our site.

Thanks for your help

Gavin

<?xml version="1.0" encoding="utf-8" ?>
<Product xmlns="http://schemas.microsoft.com/developer/2004/01/bootstrapper" ProductCode="MS.Access.2007.Runtime.Package">
<InstallChecks>
<MsiProductCheck Property="IsMsiInstalled" Product="{90120000-001C-0409-0000-0000000FF1CE}"/>
</InstallChecks>
<Commands>
<Command PackageFile="accessruntime.exe" Arguments=" /passive" EstimatedInstallSeconds="120">
<InstallConditions>
<BypassIf Property="IsMsiInstalled" Compare="ValueGreaterThan" Value="0"/>
</InstallConditions>
<ExitCodes>
<ExitCode Value="0" Result="Success"/>
<ExitCode Value="1641" Result="SuccessReboot"/>
<ExitCode Value="3010" Result="SuccessReboot"/>
<DefaultExitCode Result="Fail" String="GeneralFailure"/>
</ExitCodes>
</Command>
</Commands>
<PackageFiles>
<PackageFile Name="accessruntime.exe" HomeSite="http://CHANGETHIS/accessruntime.exe" PublicKey="3082010a0282010100bd72b489e71c9f85c774b8605c03363d9cfd997a9a294622b0a78753edee463ac75b050b57a8b7ca05ccd34c77477085b3e5cbdf67e7a3fd742793679fd78a034430c6f7c9bac93a1d0856444f17080df9b41968aa241cfb055785e9c54e072137a7ebce2c2fb642cd2105a7d6e6d32857c71b7ace293607cd9e55ccbbf122eba823a40d29c2fbd0c35a3e633dc72c490b7b7985f088ef71bd435ae3a3b30df355fb25e0e220d3e79a5e94a5332d287f571b556a0c3244ef666c6ff0389cef02ad9aa1dd9807100e3c1869e2794e4614e0b98cd0756d9cac009c2d42f551b85af4784583e92e7c2bbb5dcd196128ad94430ac56a42ffb532aea42922de16e8d30203010001"/>
</PackageFiles>
</Product>

Hi SmartFX,

Is the application includes runtime 2007 running the same machine and same configuration as the one includes runtime 2003 which used to work OK? Did you check out other factors? For example, is the installation is blocked by firewall or anti-virus? Are the components for office runtime downloaded successfully?

Best regards,

Bruce Zhou

MSDN Subscriber Support in Forum

If you have any feedback on our support, please contact msdnmg@microsoft.com

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi Bruce,

I have tested on several machines including ones that will install the 2003 version.
There are no firewalls or anti-virus installed on one of the test machines to discount these issues.

ClickOnce downloads the files successfully. If I browse to them and then try and run I get two results:

1. If I run the setup.exe then I get a security prompt to allow installation of Access Runtime but then it just hangs. I never see a license agreement

2. If I run the accessruntime.exe I get the license agreement and it installs fine

I dont understand why there seems to be a difference with me running the file or setup.exe running the file

Cheers

Hi SmartFX,

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi Bruce,

This is going to sound a bit stupid but how do I login as 'administrator' under vista/windows 7? I only have one account and it is an administrator ...........

Re the log, I have pasted below. Please note that it shows as user cancelled but this is just me trying to get out when nothing happens.
As you will see the log looks like everything is working fine it seems to me that it is only that I can't SEE the EULA to allow the installation to actually happen

The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 6.1.0 {version}
Running checks for package 'Microsoft SQL Server Native Client', phase BuildList
Running MsiProductCheck with ProductCode '{BD68F46D-8A82-4664-8E68-F87C55BDEFD4}'
MsiQueryProductState returned '5'
Setting value '5 {int}' for property 'SQLVER'
The following properties have been set for package 'Microsoft SQL Server Native Client':
Property: [SQLVER] = 5 {int}
Running checks for command 'Microsoft SQL Server Native Client\sqlncli.msi'
Result of running operator 'ValueGreaterThanEqualTo' on property 'SQLVER' and value '3': true
Result of checks for command 'Microsoft SQL Server Native Client\sqlncli.msi' is 'Bypass'
'Microsoft SQL Server Native Client' RunCheck result: No Install Needed
Running checks for package 'Windows Installer 3.1', phase BuildList
The following properties have been set for package 'Windows Installer 3.1':
Running checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true
Result of checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
'Windows Installer 3.1' RunCheck result: No Install Needed
Running checks for package '.NET Framework 3.5', phase BuildList
Reading value 'Install' of registry key 'HKLM\Software\Microsoft\NET Framework Setup\NDP\v3.5\1033'
Read integer value 1
Setting value '1 {int}' for property 'DotNet35InstallSuccess'
The following properties have been set for package '.NET Framework 3.5':
Property: [DotNet35InstallSuccess] = 1 {int}
Running checks for command 'DotNetFX35\dotNetFx35setup.exe'
Result of running operator 'ValueEqualTo' on property 'DotNet35InstallSuccess' and value '1': true
Result of checks for command 'DotNetFX35\dotNetFx35setup.exe' is 'Bypass'
'.NET Framework 3.5' RunCheck result: No Install Needed
Running checks for package 'Microsoft Access 2007 Runtime', phase BuildList
Running MsiProductCheck with ProductCode '{90120000-001C-0409-0000-0000000FF1CE}'
MsiQueryProductState returned '-1'
Setting value '-1 {int}' for property 'IsMsiInstalled'
The following properties have been set for package 'Microsoft Access 2007 Runtime':
Property: [IsMsiInstalled] = -1 {int}
Running checks for command 'Microsoft Access Runtime 2007\accessruntime.exe'
Result of running operator 'ValueGreaterThan' on property 'IsMsiInstalled' and value '0': false
Result of checks for command 'Microsoft Access Runtime 2007\accessruntime.exe' is 'Install'
'Microsoft Access 2007 Runtime' RunCheck result: Install Needed
Installation of components 'Microsoft Access 2007 Runtime' was accepted.
Copying files to temporary directory "C:\Users\Gavin\AppData\Local\Temp\VSD2B6B.tmp\"
Downloading files to "C:\Users\Gavin\AppData\Local\Temp\VSD2B6B.tmp\"
(24/08/2009 5:08:26 p.m.) Downloading 'Microsoft Access Runtime 2007\accessruntime.exe' from 'http://www.smartfx.co.nz/download/packages/microsoft access runtime 2007/accessruntime.exe' to 'C:\Users\Gavin\AppData\Local\Temp\VSD2B6B.tmp\'
Download completed at 24/08/2009 5:10:50 p.m.
Verifying file integrity of C:\Users\Gavin\AppData\Local\Temp\VSD2B6B.tmp\Microsoft Access Runtime 2007\accessruntime.exe
WinVerifyTrust returned 0
File trusted
Running checks for package 'Microsoft Access 2007 Runtime', phase BeforePackage
Running MsiProductCheck with ProductCode '{90120000-001C-0409-0000-0000000FF1CE}'
MsiQueryProductState returned '-1'
Setting value '-1 {int}' for property 'IsMsiInstalled'
The following properties have been set for package 'Microsoft Access 2007 Runtime':
Property: [IsMsiInstalled] = -1 {int}
Running checks for command 'Microsoft Access Runtime 2007\accessruntime.exe'
Result of running operator 'ValueGreaterThan' on property 'IsMsiInstalled' and value '0': false
Result of checks for command 'Microsoft Access Runtime 2007\accessruntime.exe' is 'Install'
'Microsoft Access 2007 Runtime' RunCheck result: Install Needed
Verifying file integrity of C:\Users\Gavin\AppData\Local\Temp\VSD2B6B.tmp\Microsoft Access Runtime 2007\accessruntime.exe
WinVerifyTrust returned 0
File trusted
Installing using command 'C:\Users\Gavin\AppData\Local\Temp\VSD2B6B.tmp\Microsoft Access Runtime 2007\accessruntime.exe' and parameters ''
User has cancelled install
Process exited with code 1
Status of package 'Microsoft Access 2007 Runtime' after install is 'InstallFailed'

Hi Bruce,

Quick update, I have tried logging on as Administrator but with the same result.
The downloaded package accessruntime.exe works fine when run manually but doesn't seem to run when asked to by setup.exe.
There must be something really basic that I'm doing wrong but I just can't work it out!

Cheers

Hi SmartFX,

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi Bruce

More updates. I have now discovered that the install works if I use the "/passive" switch as this stops the installation package from showing the EULA. This doesn't really make sense to me but it works so all good really.

For anyone else who is interested I have pasted the product.xml file below.
The only thing left now is if anyone could give me a Microsoft URL to use as the 'HOMESITE' so we dont have to host the installation package on our site.

Thanks for your help

Gavin

<?xml version="1.0" encoding="utf-8" ?>
<Product xmlns="http://schemas.microsoft.com/developer/2004/01/bootstrapper" ProductCode="MS.Access.2007.Runtime.Package">
<InstallChecks>
<MsiProductCheck Property="IsMsiInstalled" Product="{90120000-001C-0409-0000-0000000FF1CE}"/>
</InstallChecks>
<Commands>
<Command PackageFile="accessruntime.exe" Arguments=" /passive" EstimatedInstallSeconds="120">
<InstallConditions>
<BypassIf Property="IsMsiInstalled" Compare="ValueGreaterThan" Value="0"/>
</InstallConditions>
<ExitCodes>
<ExitCode Value="0" Result="Success"/>
<ExitCode Value="1641" Result="SuccessReboot"/>
<ExitCode Value="3010" Result="SuccessReboot"/>
<DefaultExitCode Result="Fail" String="GeneralFailure"/>
</ExitCodes>
</Command>
</Commands>
<PackageFiles>
<PackageFile Name="accessruntime.exe" HomeSite="http://CHANGETHIS/accessruntime.exe" PublicKey="3082010a0282010100bd72b489e71c9f85c774b8605c03363d9cfd997a9a294622b0a78753edee463ac75b050b57a8b7ca05ccd34c77477085b3e5cbdf67e7a3fd742793679fd78a034430c6f7c9bac93a1d0856444f17080df9b41968aa241cfb055785e9c54e072137a7ebce2c2fb642cd2105a7d6e6d32857c71b7ace293607cd9e55ccbbf122eba823a40d29c2fbd0c35a3e633dc72c490b7b7985f088ef71bd435ae3a3b30df355fb25e0e220d3e79a5e94a5332d287f571b556a0c3244ef666c6ff0389cef02ad9aa1dd9807100e3c1869e2794e4614e0b98cd0756d9cac009c2d42f551b85af4784583e92e7c2bbb5dcd196128ad94430ac56a42ffb532aea42922de16e8d30203010001"/>
</PackageFiles>
</Product>

Hi SmartFX,

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Thanks Bruce,

The HomeSite URL works perfectly.
On a kind of separate point, do you know how one finds out URLs like this?

Cheers

Gavin

Hi SmartFX,

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.