HR Management Software

HR Management Software

HRMS Tutorial & Tips


Get the problem or stuck on an Access HRMS software programming? Don't know how to update the new database software? Hope our tutorials may give you the hints that you need.

  • Why Use Microsoft Access Solution?
  • Limitation for Access Solution
  • What is the difference between Access templates and databases application?
  • 2013 Access Pivot table and Pivot chart
  • How to transfer the data over to my new updated Access database software?
  • How to import Excel data to Access Data base?
  • How to collecting information for an Access Database by E-mail
  • Compact and repair yours Access Database
  • Convert a database to the Access 2007 file format
  • Why I can not open my Access software?
  • Why all the buttons on my main page are not working?
  • Can I use my Google Doc open Access application?
  • Can not open Access 2010/2013 application on Access 2007 platform.
  • MS Access Users menu.
  • How to localization my software user interface?
  • How to setup database protection?
  • Where can I get the MS Access runtime version, if I don't have MS Access software now?
  • Microsoft Access database or project contains a missing or broken reference to the file (filename).
  • Can Microsoft Access application work on MAC platform?
  • MS Access 2010 with "Function 'DATE' in expression" Error
  • Can't run login process. (VBA code not run)
  • MS Access Run-time error '3044'
  • "Unrecognized Database Format in MS- Access" issues fixed
  • "Missing or Broken reference to file MSCAL.OCX

    • Why Use Microsoft Access Solution?

    As we all know, Microsoft Access is the most widely used desktop database system in the world. Microsoft Access is part of Microsoft Office so there is a common interface and lots of developers and support options available. It pretty much covers all the functionalities for small business needs. And it is significant less expensive than SQL Server or Oracle. For small businesses, this is the fastest and least expensive database solution to get your goals accomplished.

    Limitation for Access Solution

  • You have over 50 concurrent users.
  • Your database will be over a million records, it will be too big to work with Microsoft Access.
  • Please check the following link for more detail specifications.

    • What is the difference between Access templates and databases application?

    There is no difference in between them. All our Access templates are databases applications but don't have your data in it yet.

    Pivot table and Pivot chart on Access 2013 Microsoft has removed Pivot table and Pivot chart feature from the upcoming Access 2013. Please check on the following web for more update features list on Access 2013.

    How to localization my software user interface? You can start a DIY project for our software user interface localization. You can modify all our software UI into your local language as long as Microsoft Windows support your local language. Please open your forms on desigh mode and change all the UI items label to your own language and save the change.

    MS Access Users menu. If you don't know how to use MS Access tools, please check the following link for Microsoft Access User's Menu.

  • MS Access 2007 User's Guide from Microsoft
  • MS Access 2010 User's Guide from Microsoft
  • MS Access 2013 Quick Start Guide from Microsoft

    • How to import Excel data to Access Database? Please make sure the you Microsoft Excel data is in right format. Each column has a label in the first row and contains similar facts, and there are no blank rows or columns within the list. then close the Excel work book who contain the data you want to import to Access database. Open the Access database and click Import from Get External Data under File menu. In the Import dialog box, click Microsoft Excel in the Files of type box. find the file you want to import, and then double-click the file. Then Follow the directions in the Import Spreadsheet Wizard. More Detail.



    How to collecting Information for an Access Database by E-mail Access 2007 makes it easy to gather data from people who are located anywhere on the globe, such as members of your team, or your contacts. Office Access 2007 works with Microsoft Office Outlook 2007 to help you to generate and send an e-mail message that includes a data entry form. When the recipients fill out the forms and send them back to you, the replies are processed according to your specifications. For example, if you choose to have the replies automatically processed, the contents of the form are added to the appropriate table in your database as soon as the reply reaches your inbox. This new feature, the Collect data through e-mail messages Wizard, can save you hours that you might have otherwise spent entering data on behalf of your users. Please visit Microsoft Office website for More detail

    How to compact and repair your Access Database From time been, Access databases grow in size and unnecessarily use disk space. Additionally, repeated modifications to the database file may result in data corruption. This risk increases for databases shared by multiple users over a network. It's a good idea to periodically run the compact and repair database tool to ensure the consistency of your data.

  • Instruct other users to close the database. You must be the only user with the database open in order to run the tool.
  • Click the Microsoft Office button, from the menu, choose "Manage", then "Compact and Repair Database"
  • Access will present the "Database to Compact From" dialog box. Navigate to the database you wish to compact and repair and then click the Compact button
  • Provide a new name for the compacted database in the "Compact Database Into" dialog box, then click the Save button.
  • After verifying that the compacted database works properly, delete the original database and rename the compacted database with the original database's name.

    • Can not open Access 2010/2013 application on Access 2007 platform.

    Microsoft Access 2010 introduces features that are not supported in Microsoft Office Access 2007. Access 2007 Service Pack 1 (SP1) will not open databases containing these features; Access 2007 Service Pack 2 (SP2) will in some cases offer limited viewing and designing capabilities. Therefore, installing SP2 will help you access more applications created in Access 2010. More detail


    How to transfer the data over to my new updated Access database software? When you get the new version of your Access database software, you need to transfer your old data to the new update software. First, you need to export the data from your database to a .XML file, then open your new updated software and import the data from that .XML file. Please click the following link and find out more detail from Microsoft's tip.

  • Importing and Exporting XML Data Using Microsoft Access

    • Convert a database to the Access 2007 file format

    You can convert a database that was created by using Microsoft Access 2003, Access 2002, Access 2000, or Access 97 to the new Microsoft Office Access 2007 file format. You should use the new file format whenever possible because it supports new features, such as multivalued fields and attachments. But database in the new Access 2007 file format (.accdb) cannot be opened or linked to with earlier versions of Access, also the new format no longer supports replication or user-level security. If you need to use your Access 2007 database with earlier versions of Access, or if you need to use replication or user-level security, you MUST use a file format from an earlier version.


    Why I can not open my Access software?

    You can not use Access 2003 platform open Access 2007 templates, since the file format are different, the better way to fix this problem are convert Access 2007 application to Access 2003 format or update your MS Office Access platform to Access 2007.



    How to setup database protection?

    Database Protection helps you to protect your Access database by encrypting it with a password

    To encrypt the database with a password

  • Open database on exclusive mode
  • Click File > Info > Encrypt with Password.
  • Type a password in the Password and Verify boxes.

    • The password you enter isn't stored with the file and is used to generate keys to encrypt the file.

    To remove password and encryption on the database

  • Click File> Info > Decrypt Database.
  • Type your password in the Password box.

    • More detail about Microsoft Access 2013 privacy supplement.


    Why all the buttons on my main page are not working?

    This kind of problem may costed by your Access platform version missed matching, please make sure all your MS Office software are at same version before you start debugging on your Access application.


    Where can I get the MS Access runtime version?

    All our HR management software are written in MS Access. If you do not own Microsoft Access 2013 or 2016 there is no need to purchase it right now, please check on the following link for download the runtime MS Access from Microsoft:

  • Download Microsoft Access 2013 Runtime
  • Download Microsoft Access 2016 Runtime
    • We do however recommend having the purchased version of Microsoft Access as it enhances the end user experience.


    Can I use Google Doc open my MS Access applications?

    Not yet!

    Microsoft Access database or project contains a missing or broken reference to the file

    If you have a procedure that contains a Visual Basic for Applications function and your database contains a reference to a missing object library or type library, you may have " Microsoft Access database or project contains a missing or broken reference to the file (filename)" error message, please remove the missing reference, follow these steps:

  • Open your database.
  • Press ALT+F11 to open the Visual Basic Editor.
  • On the Tools menu, click References.
  • Click to clear the check box for the type library or object library marked as MISSING: (referencename).
  • More detail

    • Can Microsoft Access application work on Mac platform?

    No. On the Mac OS, Microsoft Office offered several versions of Outlook in the late 1990s, but only for Word, Excel, PowerPoint and Outlook..... Microsoft does not include its Access database application in Office for Mac.



    MS Access 2010 with "Function 'DATE' in expression" Error As we know, MS Access 2010 date functions not working after migrating from MS Access 2003, please check the following link for more detail: Date() function at MS Access 2010

    Can't run login processIn order to run the login process, you need to let your computer set to trust this MS Access application. please check the following link for more detail

    MS Access Run-time error '3044' Please check the following link and try to download the runtime error 3044 MS Access repair tool


    MS Access "Unrecognized Database Format" issues fixed.

    There are 2 reason will caused this problem:

  • Chances of database corruption:Using the inbuilt repair utility to fix it. MS-Access has an inbuilt repair tool that can be deployed by following the settings given below: Tools->Database Utilities->Compact and Repair Database
  • Opening the MS-Access Database File in Previous Versions: Ensure that the following settings are carried out: FIle->Options->General->Creating database->New database sort order

    • Missing or broken reference to file MSCAL.OCX

    This problem is caused by you missing calendar control OCX on your MS Access platform, and here is how to fix this issues:

  • Get a copy of MSCAL.OCX onto you computer running Access and other versions of the mscal.ocs at Fontstuff Website, Downloading and Extract the files from the zip archive and copy them in to your copy/paste buffer.
  • Goto your c:\windows\syswow64 folder and paste the mscal.ocx file. (you don't need the .hlp). (Place the file in c:\windows\system32, for 32 bit Windows 7 computers .)
  • Press your Start Button and type 'command' in the little search window. Several entries will be shown. Near the top will be Command. Right click this choice and select "Run as Administrator". The black DOS command prompt window will appear.
  • Goto DOS command line type: %systemroot%\SysWoW64\regsvr32.exe mscal.ocx (you need to use: %systemroot%\system32\regsvr32.exe mscal.ocx on a 32 bit windows 7 )
  • You should receive a message indicating the file was successfully registered.