Implementation method to prevent MDB database from being downloaded under IIS _win server

There are generally two ways to resolve an access (MDB) database to prevent downloads:

The First approach: Require Web site managers to specific ASP programming experience.
Because the current sales of the virtual host system, has created a database directory for users, with the same level of the Web directory, users access to the Web files, but not access to the database directory files. So we have to put the database file into the databases directory can be, but not so easy to achieve, need to get the actual MDB file directory, mainly connected to the database, need to be modified.

Here is a concrete idea. Gets any file in the Web root directory first. For example

Then the address of the database is E:\database\123.mdb.
When connecting to the database, the code is connstr= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\database\123.mdb"

The second method: It is relatively simple, if it is a virtual host user, you can find the Server Manager to set up well. If you have server administration privileges, you can do so by doing the following.

How do I prevent an MDB database from being downloaded? This article discusses the server-side to prohibit the MDB format database files are downloaded, rather than adding an anti-download table in the database, the database name to include the # Number of ASP, ASA and other suffix format.
The following example shows how to disable the download of the MDB database on server-side settings IIS6.0. Create a new Notepad file that does not fill in any content, change the file name to NoDownload.dll, copy it to the C:\Windows\System32\ (Win2000 C:\WinNT\ system32\) directory, and open the IIS Service Manager. Select the site you want to set up, right-click, select Properties, open the Site Properties dialog box, switch to the Home Directory tab, click the "Configure" button below



Eject the Application Configuration window, click the "Add" button below in the Mappings tab, and eject the Add/Edit Application Extension Mapping window
Click the "Browse" button to locate the NoDownload.dll file, enter ". mdb" in the "extension" text box, and set the action to: all actions, click OK to save the settings.

This will prompt the HTTP 404 error when you enter the database address directly, prompting the "file or directory not found" and downloading tools such as FlashGet are not available.