Using / Activating Windows Installer for Access Runtime

[Harris]

If I could ask for some advice on a small problem (hopefully).
I need users to be able to install Access Runtime 2002/XP.
The setup file is called ACCESSRT.MSI which is activated and run by Windows Installer (called msiexec.exe).

I have tried to install using the pre-installed Windows Installer (msiexec.exe) present in the system directory, or by including the file on the CD with the other Access Runtime files, but cannot get the install to work.

Some ways I tried was

File to execute: %SysDir%\msiexec.exe
Command line parameters: "%SrcDrv%\Runtime\ACCESSRT.MSI"

File to execute: %SrcDrv%\Runtime\msiexec.exe
Command line parameters: "%SrcDrv%\Runtime\ACCESSRT.MSI"

File to execute: %SrcDrv%\Runtime\msiexec.exe
Command line parameters: /a "%SrcDrv%\Runtime\ACCESSRT.MSI"

Has anyone know a solution?

If I use the Open Document command, it will activate, run and install correctly but while this is happening, on Factory Setup the next screen is displayed before the install is complete, something that you can prevent and control with the Execute command.

Thanks
Harris

[Brett]

Answered here (http://www.indigorose.com/ubbthreads/showflat.php?Cat=&Board=UBB7&Number=15821&page=0&v iew=collapsed&sb=5&o=0&fpart=).

[Harris]

Fantastic!
Works perfectly - thanks a ton.

For others in a similar predicament - trying to distribute programs requiring Access Runtime for 2002/XP:

To install Access Runtime:
1. Distribute the Runtime Package on the CD.
2. The installation "install" file ends .msi, i.e. Accessrt.msi and requires Windows Installer i.e. msiexec.exe, usually in the SysDir, to "run"
3. Check if Access2002/XP is installed by checking the registry location: HKEY\LOCAL\MACHINE\SOFTWARE\Microsoft\Office\10.0\ Access
4. To install the runtime, use the Command setting as stated by Brett (above)
File to execute: %SysDir%\msiexec.exe
Command line parameters: /i "%SrcDrv%\Runtime\ACCESSRT.MSI"
Set "Wait for program to end before continuing" active.
5. When Runtime installation is completed, Setup Factory's next screen offers to install your program. Install your program / database.
6. Now read the install path to Access 2002: HKEY\LOCAL\MACHINE\SOFTWARE\Microsoft\Office\10.0\ Access\InstallRoot
7. Create a shortcut key linking your program to the Runtime msaccess.exe by: Command - Create Shortcut
Folder: %Desktop%
Target File: %RegistryAccess10%\MSAccess.exe where %RegistryAccess10% = value from Step 6 above.
Command Line arguments: "%AppDir%\NameOfDatabase.mde"

Regards,
Harris