• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 984
  • Last Modified:

Microsoft Access Payroll

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.
2 Solutions
Patrick MatthewsCommented:
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.


Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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 (http://www.microsoft.com/downloads/details.aspx?FamilyId=D9AE78D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en). 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: http://www.innovasys.com/products/hs3/overview.aspx. 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

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now