Best version of Microsoft Access

Posted on 2006-06-07
Medium Priority
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
  • 2
LVL 44

Accepted Solution

Leigh Purvis earned 200 total points
ID: 16857883
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
ID: 16857979
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).

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 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