Access Database Routine maintenance method (optimization) _access

The scope of this article: use Access as a database building site.

Security for Access databases

1, to ensure that Access database can not download directly, that is, the HTTP way can not directly download your database. If you can download, hackers will be used to steal all the information on your site.

2, rename the Access database into a more complex name, do not use the default MDB extension, and do not use ASP as an extension. It is recommended that you do not use an extension or a special extension, such as KJJE4#55.AAA.

Database size do not exceed 50M

1, the practice concludes that when the Access database exceeds 50M, the overall response of the site will become very slow, but also affect the performance of other Web sites on the server. If the data is very large, we recommend that you migrate to our SQL Server database space.

2, if your site has a message, such as interactive page, please be sure to set up the verification code and other protective measures, lest be hackers poured into a large number of data, the database continues to become big disadvantage.

3, when we design the program, please note that the end of the page plus the database close code, conducive to the good operation of the site. The code example is as follows:

Copy Code code as follows:

Rs.close
Set rs=nothing
Conn.close
Set conn=nothing

Compression and Repair

Access database If the long time does not maintain, prone to the database is too large, slow to read or even corrupted, and so on the site to open the error or abnormal, then we can use Microsoft Access software for compression and repair.

1, pause the Web site, so that Access database no longer read and write.

2, through the FTP software to download the Access database to the local computer.

3, copy this database as a backup, so as not to repair failure caused by database damage.

4, use Access software to open this database. Click the tools in the top menu bar to-> the database utility, and then click the Compress and Repair database.

5, the repair of the database uploaded to the space, overwriting the original database. Finally open the space.