A little experience in using medium-sized Access database for a long time_PHP tutorial

In the process of using the Access database, the operations of deleting and adding records are often performed continuously, and the following problems will occur:
1. The Update statement may fail. A record obviously exists and can be selected, but when using An error message that the record cannot be found and the update failed appears during Update.
2. It will increase the size of the database and reduce the efficiency of database operations
3. When deleting records, it will not reduce the size of the database, and there will be no Corresponding statements that can improve the database
Solution
Download the Access database, open it with Access software, and process it with the "Repair and Compress Database" tool. After saving, re-upload and overwrite the original database to solve the above problem. All problems. This method is only suitable for small and medium-sized databases. For large databases, it will be too slow to upload and download.

http://www.bkjia.com/PHPjc/631210.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631210.htmlTechArticleIn the process of using the Access database, the operations of deleting and adding records are often performed continuously, and the following problems will occur: 1. It may cause the Update statement to fail. Even though a record exists, it may also...