Microsoft Access Payroll

Posted on 2009-02-17
Last Modified: 2013-11-12
Hi I have a payroll application in Microsoft Access which I wrote and it work very well. Now I am about to distribute it to various clients who might want it. How do I ensure that it work with all version of MS Access and what is the best way to ensure that there is no problems with the libraries.
Question by:tristan69
    LVL 92

    Accepted Solution

    Hello tristan69,

    For one thing, distribute in the Access 2000 file format, which newer Access versions can support, but which
    will mean that any new goodies only available in the newer versions will not be supported.

    For another, use late binding for any automation involving other applications.


    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    There are a host of issues when dealing with an Access app "in the wild". Patrick has provided you a solid starting point.

    1) Are you going to support users who do NOT have Access installed? If so, you'll need to insure that your app works as expected in the Runtime version of Access. You can get the 2007 runtime free ( Users could either download it directly, or you can distribute it along with your application. 2007 runtime should run your application, but test it thoroughly if you go this route.

    2) Have you included error handling for EVERY VBA procedure?

    3) Are you using any Activex controls (i.e. calendars, etc)? If so, you'll have to distribute them along with your app (and you'll need the rights to do so).

    4) Do you have a compiled Help file? Users will expect a standard Windows help file. Possibly the best help authoring system is here: Yes, it's pricey but it does a great job.

    5) Do you have the app packaged with an installer (i.e. a standard Windows install package)? Clients will expect this. There are plenty of free ones out there (search for "free installers") or you can purchase one (I use Wise for Windows, and it works very well, but is quite pricey). An installer can do many things, but to me the most important is that it can validate the user environment before installing ... that is, if you require that Internet Explorer 6.0 or greater be installed, a professional installer can check for this first.

    There are plenty of other issues as well ... I'll let you digest those and see what else I can come up with.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    729 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

    18 Experts available now in Live!

    Get 1:1 Help Now