Check for Access 2003 before installing runtime

[Josh]

I have 2 .msi packages. The first one has access 2003 runtime, the
second package has the program with just access 2003. I want to be
able to combine the 2 packages and have the installer to check to see
if Access 2003 is installed or not... If it is installed then I want
the non-runtime version to install, and if Access 2003 is not
installed then I want the runtime version to install. I am using Orca
for my editor, because I can't afford Wise or Installshield so if
anyone has any info that could help, I would greatly appreciate it...

 

[Daniel]

The following post might answer your question

http://groups.google.ca/group/micro...read/thread/9e5c5996a6c4a387/8e1517c1503743d2

Daniel

 

[Daniel]

I realized my last post was probably useless because it was vba code... You
could use vbs or something similar to check the registry.... Probably best
to repost in the appropriate group. i did however find this

Dim oShell
Set oShell= CreateObject("WScript.Shell")
Select Case oShell.RegRead("HKCR\Access.Application\CurVer\")
Case "Access.Application.8"
AccessVersion = 8 '97
Case "Access.Application.9"
AccessVersion = 9 '2000
Case "Access.Application.10"
AccessVersion = 10 '2002
Case "Access.Application.11"
AccessVersion = 11 '2003
Case "Access.Application.12"
AccessVersion = 12 '2007
End Select
Set oShell= Nothing
Wscript.Echo AccessVersion

Daniel