Problems installing Access Runtime 2007 with clickonce

Question

I have been trying to install Access Runtime 2007 as part of a clickonce installation by creating a 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?

Answer 1

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 [e-mail]

 

---

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.

Answer 2

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

Answer 3

Hi SmartFX,

Thanks for your information. I am not sure if the problem is caused by permission. Have you ever tried installing the clickonce application under administrator account? If not, would you please have a try?

Second, would you please get out the installation log and post it here. If you don't know how to get the log since the applciation hangs, you can refer to this blog on how to get the log file out. 

Best regards,

Bruce Zhou

---

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.

Answer 4

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'

Answer 5

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

Answer 6

Hi SmartFX,

Did you get the log file after you kill the installation process? If so, it makes sense that log file indicates user cancelled the installation. From the log file, I can only see the installation of accessruntime.exe might be blocked. I am not sure if it is because the passed parameters is empty string. 

As you said, you can install the application successfully when you include Office 2003 accessruntime.exe. Would you please try to install the application with Office 2003 accessruntime.exe again, and get the log file? After that, we can take a comparison with these two log files, probably we can find something useful.

Best regards,

Bruce Zhou

MSDN Subscriber Support in Forum

If you have any feedback on our support, please contact [e-mail]

---

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.

Answer 7

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>

Answer 8

Hi SmartFX,

Great, thanks for sharing your solution. As for  the HomeSite, you can try the following:

http://download.microsoft.com/download/D/2/A/D2A2FC8B-0447-491C-A5EF-E8AA3A74FB98/AccessRuntime.exe

Best regards,

Bruce Zhou

MSDN Subscriber Support in Forum

If you have any feedback on our support, please contact [e-mail]

---

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.

Answer 9

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

Answer 10

Hi SmartFX,

Enter the keyword "Access Runtime" in the search engine like "Bing". You may see the first hit is the download site of the Access Runtime.

Best regards,

Bruce Zhou

MSDN Subscriber Support in Forum

If you have any feedback on our support, please contact [e-mail]

---

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.