Install access control database, the advantages and disadvantages of ACCESSS database and SQL database
2017-02-26 11:59
Details of the problem:
When installing access control software, how to correctly choose to use ACCESS database or SQL database?
Expert answer:
Hello! Thanks for using our company's products! Our company's software uses Access database by default, which is a small database that comes with this operating system and does not require installation. It is recommended that the number of cards does not exceed 200 people, and the number of card swiping records per day does not exceed 1,000. Beyond this range, data loss may occur. If the number of cards is greater than 200 or the card swiping records are more frequent, use the map and video capture function, it is recommended that you use SQL database, it is recommended to install SQL2005 or above.
