Microsoft Access Database Password Support

Version 1.6.2 of Time Clock MTS was released today. It contained a couple of minor bug fixes and added one very important security feature, support for Microsoft Access database passwords.

Users finding and manipulating the back end database of Time Clock MTS has always been a problem. Time Clock MTS has always included a series of internal checks to try to detect this sort of manipulation, but of course no system is perfect. By including support for Access database passwords we have added one additional layer of security to ensure that your time and attendance information is accurate. Using a database password with a Microsoft Access database encrypts the data it contains and prevents non authorized access to the database when someone tries to open it with MS Access.

To setup Time Clock MTS to work with an Access database that is password protected follow these simple steps:

1. Password protect your Access database using MS Access. How this is done depends largely on the version of MS Access that you have. Consult your MS Access help documentation for detailed instructions.
2. Run the Time Clock MTS administrator program, the software will detect that the database back end is password protected and prompt you to enter the password.
3. Once entered click OK and re-start the software as prompted. If you entered the information correctly then you’ll connect directly to the database. If you didn’t enter the password correctly you’ll be prompted to enter it again.
4. You’ll need to repeat the password entry process for every client installation you have.

That’s all there is to it. If you’re wondering, the MS Access database password you enter into Time Clock MTS is stored locally on each computer (which is why you need to enter the password for every Time Clock MTS Client you have). The password itself is stored in an encrypted format for extra security.