During the use of Access database, the following problems will occur frequently and continuously delete and add records:
1. The update statement may fail. Even though a record exists, it can also be selected, but when using Update, the record cannot be found, the update error message is not updated.
2. It will increase the database and reduce the efficiency of database operations
3. The database size will not be reduced when deleting records, and there are no corresponding statements that can improve the database.
Solution
Download the Access database, open it with Access software, and use the "Repair and Compress Database" tool to process it. Save it and then upload it again and overwrite the original database to solve all the above problems. This method is only suitable for small and medium-sized databases. If the large ones are downloaded, it will be too slow.
1. The update statement may fail. Even though a record exists, it can also be selected, but when using Update, the record cannot be found, the update error message is not updated.
2. It will increase the database and reduce the efficiency of database operations
3. The database size will not be reduced when deleting records, and there are no corresponding statements that can improve the database.
Solution
Download the Access database, open it with Access software, and use the "Repair and Compress Database" tool to process it. Save it and then upload it again and overwrite the original database to solve all the above problems. This method is only suitable for small and medium-sized databases. If the large ones are downloaded, it will be too slow.