Microsoft Access Database Simplifies Ingress Implementation
Ingress now is available
with a different database format, Microsoft Access which will be utilized as
the default database for Ingress Software in the near future.
Since its initial release,
Ingress has been designed to work with the MySQL database which is known to be powerful,
reliable and widely used by many other systems. However, the downside of the MySQL
Database is that the configuration requires advanced IT knowledge and expertise,
which is scarce in SMEs without IT departments or personnel.
Acknowledging this
challenge, our R&D had been putting in efforts to link up Ingress software
with Microsoft Office Access database. Basically, this method will run the
FingerTec Ingress software installation file to install and create the
Microsoft Access database by itself. This is a one-kick-to-go process which pose
no challenge to anybody.
Without having to install
any additional components, the Microsoft Access database can run by itself. The
database file with the extension of .mdb is automatically generated in Windows
OS. However for those with IT knowledge and expertise, it is highly recommended
to install the Microsoft Access database along with the Microsoft Jet Database
Engine which provides a graphical user interface to manipulate data or to
produce your own reports.
The Microsoft Access
database easily integrates with other software in Windows OS. For example, it
is possible to connect payroll solution to the database to obtain attendance
information that is produced by Ingress software to assist with report
preparation. The database can also be utilized along with the Microsoft .NET
Framework development.
This database can grow up
to 2GB which is more than sufficient for most SME businesses. The backup and restoration of the database is
provided as part of the Ingress software for easy housekeeping without having
to install any other software and it can also support multiple-user logins from
within the same network.
Nonetheless, there are
some areas that require precaution when running the Microsoft Access database.
First, the database file
cannot expand beyond 2GB. When the database reaches its max storage limit, data
delay will appear in the software. Therefore, consistent housekeeping of database
is crucial to avoid any interruption in the flow in of data.
Secondly, there is only
one MDB file which is used to save and store all data (tables, queries, forms,
reports, macros and modules). Therefore, please make sure that it is secure
from external interruptions. Expending the one-database-file size would slow
down the performance of queries and reports.
Finally, it is not advisable to use this database for multiple user
logins via server-client concept. This corrupts the MDB file easily. Thus, it is
preferable to instead utilize the database as a single installation into one(1)
computer for single/one(1) person operation. However, different login authority
can be assigned to different users such as the system administrators, operators
or HR personnel for them to login with different usernames and passwords into
Ingress to do their job.
With the availability of
the Microsoft Database, we hope that we have solved the quandary of Ingress
deployment for most companies and the acceptance of Ingress will not be an
issue anymore.
Microsoft
Access database
|
MySQL database
|
|
Installation
|
Easy
Database file created by Windows OS
automatically
|
Moderate
IT expert is required to install the
database
|
Server
installation
|
Yes
|
Yes
|
Client
installation
|
No
|
Yes
|
Extension
|
.mdb
|
.sql
|
Storage limit
|
2GB
|
2GB
|
Housekeeping
|
Yes
|
Yes
|
3rd
party tool to manage
|
Optional
Microsoft Jet Database Engine
|
Yes
SQL Yog
|
Capability for
server-client operation
|
No
|
Yes
|
Suitable for
|
Company without IT personnel/department
|
Company with multiple system running
on MySQL
|
You can now click http://www.fingertec.com/download/ingress-MDB.zip to download the Ingress with Microsoft Access database
what is the default password for open the access database
ReplyDeleteDear Mr Sundar,
DeleteGood day to you,
May I know are you referring to the MDB database file? Please be informed that we are not allowed for any end user to directly access the database due to privacy issue. You may refer here for our database T&C:
http://www.fingertec.com/ftdatabaseterms/index.php
If you want to get any details, you can export the data from data audit list or attendance sheet from our software into your preferred format then you may import to your third party software.
Hello,
ReplyDeleteHow can i login??there is no default username and password. this is new installation and we need to build attendance databas..How can i make it?
Hello Sir,
DeleteGood day to you.
With regards to your query, if you want to login to Ingress software, the default username and password is as below details :
username : admin
password : 123
Please revert back should you need further assistance on above matter.
Hi,
ReplyDeletecurrently i use database type MDB. if i want to change to database type MYSQL, what i need to do? is the current data and setting will be loss and need to setting again?
Hello Sir,
DeleteGood day to you.
Regarding your query, if you would like to convert the database from MDB to mySQL, please send your MDB database to support@fingertec.com so that our team can assist you to convert it to mySQL database.
In your own pc, please reinstall the software using installer below, and restore the database once you receive the converted database from our end :
Ingress server (mySQL) installer : https://www.fingertec.com/softwareupdate/ingress/software-ingress_download_e.html
Hi,
ReplyDeletehow long will it take for your team to convert database type MDB to mySQL?