Difference between Access 97 retail and runtime version

Posted on 2004-10-28
Last Modified: 2012-08-13

I need to collect information through SMS.
The objective is to define exactly the number of Access 97 (and only 97) we have : retail or runtime only.
I only need to know which file(s) is installed with retail and not with runtime.
If it's a registry key, solution is welcome too. I can create a specific script to deploy with SMS for a MIF solution. But file(s) difference would be great.

300 points because I need an urgent solution and something that answer exactly - file or reg key.
Can increase if you want, no problem.

Question by:dsegard
    LVL 83
    An Access database is an Access database, there are not different "versions" of the database for runtime vs full retail. The Access Runtime is basically the full version of Access with design capabilities removed.

    Are you instead wanting to know what machines have the full version of Access97 installed? This can be checked at this registry key:


    If you find a value in the "Path" at this key, then Access97 is installed
    LVL 3

    Author Comment

    Thanks LSMConsulting,

    About your first comment, I know that... just have a look to my profile.

    My main problem is to have an immediate solution, I don't have time to install 2 differents PC to check myself, I only have 1 or 2 hours to give the results... and I can't verify on existing PCs as I'm in a distant place...

    What about wizards files ? Don't remember if they are installed with runtime, probably not but not sure.

    LVL 83

    Accepted Solution

    Hmmm ... not sure, but I'd bet they're not. The accwiz.dll would be the place to work, but I can't verify that ... and while I've found references to specific reg keys that are built for runtime installs, I can't find the exact keys needed to accurately determine if the 97 runtime has been installed. Hopefully someone else will be able to help you ... good luck.
    LVL 3

    Author Comment

    I don't need to know if runtime is installed. If MSACCESS.EXE is found, we are sure something is installed, retail or runtime.
    The most difficult, is to know after which of them as EXE is the same in both case and all other files, excepte some I don't know...
    Enumerate retails is my pain...
    I will start with script to search reg key.
    If you find later the answer about wizards, that would be very nice if you post an extra comment here...

    Points are yours.
    Many thanks,

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Lean Six Sigma Project Manager Certification

    There are many schools of thought around successful project management, but few as highly regarded as the Six Sigma and Lean methods. With 37 hours of learning, this training will explain concrete processes for increasing efficiency and limiting wasted time and effort.

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    856 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now