How to Set Mekari Agent with Microsoft Access Connection Type

Article author
Learning Center Mekari
  • Updated

After installing and adding settings in Talenta, then you can make settings in the Mekari Agent application. In Mekari Agent, there are several connection types that you can choose from, namely Microsoft SQL, MySQL, and Microsoft Access.

In this guide, we will explain how to set up the Mekari Agent using the Microsoft Access Connection Type. Here's the explanation:

  1. Prepare your .mdb file in Microsoft Access.

    In Microsoft Access, you can fill in employee data as shown in the image above. The data includes the corresponding Flags by row. The Access Flags property contains flags for configuring file access permissions. 

  2. When the .mdb file is ready, open the Mekari Agent application.
  3. Click “Create Connection” to open the Create Connection Wizard.

  4. Then you will enter the following page.
  5. Enter a connection name in the Connection name field.
  6. In the Integration type select Fingerprint outbound as the connection type.
  7. Then click "Token Validation", to validate the token.
  8. If the token is valid, then click "Continue".
  9. On the Connection settings page, drop down the Connection type. Then, you can select Microsoft Access.
  10. The "Next" button appears if the Test connection is successful. Click "Next" to go to the next page, where you can choose a table name from the connected database. Then, you can fill in the blanks.
  11. If all columns are filled, then you can fill in the next section, which is the mapping table database. Complete the data in the blank columns, such as Table name, Employee ID, Access time, Access date, and Flag.
  12. Next, there is an option for mapping badge number data. These fields can be filled in optionally. Click "Continue" if the data entered is correct.
  13. On the Auto sync page, you can complete the data in the columns Synchronization frequency (hourly/daily/weekly), Sync date, Sync time, Start checkpoint date, and Start checkpoint time. Click "Continue" when finished.
  14. Then, a pop-up like this will appear and click "Sync now" to start synchronizing.

This is an explanation of how to set up the Mekari Agent application. You can click here to learn how to set up Mekari Agent with Microsoft SQL and MySQL Connection types.