Best version of Microsoft Access

Posted on 2006-06-07
Last Modified: 2006-11-18

I work for a small 10 person company and I have developed a small job managing database that I want everyone to have a copy of the front end on their pc. I currently have it in access 97 where you can compile and deploy the front end. I know from another project I was involved in that in about 2000 microsoft split access into two packages the basic user and the professional. As a few years have gone by and I am not up with the play now do I have to buy the latest professional version of access too be able to compile and deploy and application?


Question by:ralstoj
    LVL 44

    Accepted Solution

    You'll need the Developer Tools - the precise nature of the package it comes with has varied over the versions.
    97 is not supported by MS any more.
    However - you'll likely be able to pick up a version of it from here and there.
    (Perhaps on a well known internet auction site or something like that - though I couldn't possibly say ;-)
    Just make sure it's legit. :-)

    If there is no functionality beyond 97 that you require then (which it still runs under Windows) you can continue with it.
    LVL 44

    Expert Comment

    by:Leigh Purvis
    Oh - and as a general comment (on the question title) - 97 is widely considered the best ever for it's time.
    But 2003 is the version of choice for many now (myself included).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    759 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

    10 Experts available now in Live!

    Get 1:1 Help Now