Four security methods for Access Database

I. Password-based give the database a random and complex name to avoid being guessed and downloaded. This method was very popular in the past, because everyone was confident in their own code. However, with the error message indicating that the database address is leaked, the database is illegally downloaded. This method is used by fewer and fewer users. 2. Add # To the database name,

I. Password-based give the database a random and complex name to avoid being guessed and downloaded. This method was very popular in the past, because everyone was confident in their own code. However, with the error message indicating that the database address is leaked, the database is illegally downloaded. This method is used by fewer and fewer users. 2. Add # To the database name,

I. Cryptographic

ToDatabaseCreates a random and complex name to avoid being guessed to be downloaded.MethodIt was very popular before, because everyone was confident in their own code. HoweverDatabaseAddress leakageDatabaseIllegal download.MethodFewer and fewer people use it.

Ii. "#" Type

InDatabase# Is added to the name. When a request is sent from a URL, # Is a separator between the request address and the request parameter.DatabaseName, for example, callbackMethod, # The special expression is % 23, for example, http://www.xx.com/access%23.mdb. then access%.mdbwill be downloaded. You can also download it directly if you use a download tool such as FlashGet.

Iii. ASP

This practice is professional, but also verySecurityIt is also a popular practice, but now many people only make half of it, just change the data name to ASP, so that you can directly use download tools such as FlashGetDatabaseDownload, suchMethodThere are two steps:

Step 1:DatabaseCreate a field in, the name is random, the type is OLE object, the content is set to single-byte type"

After the code is runDatabaseGenerate a nodownload table. The field in the table is notdown. IfDatabaseIf a data table with the same name already exists, change nodownload in the Code to the name you want.

Iv. asa type

ThisMethodIs to use IIS to protect the ASA file, so thatDatabaseFiles cannot be directly downloaded from URLs.MethodIt is misunderstood that you only need to change the file suffix to ASA. You must know that IIS only requests protection for the global. asa file name.MethodOnlyDatabaseSet the name to global. and set it to global. it is better not to place the asa in the root directory of the host or virtual directory, otherwise it will be normally global by IIS. asa file.