Allow MS Access *.mdb Files for Upload and Download

This will take a surprising number of steps to accomplish. With SharePoint on top of IIS 7, Access files (MDB) get blocked at all three layers of the service stack: IIS, ASP.NET, and SharePoint.  So simply removing them from the blocked file list in the SharePoint Central Administrator isn’t enough — both IIS and ASP.NET still have mechanisms that get in the way.

Step 1) Sharepoint MDB Blocking

There is a list of blocked filetypes in Sharepoint Central Administration –> Operations –> Security Configuration –> Blocked file types. Find *.mdb and delete from list. When you do this an entry will be automatically created in the Sharepoint site’s web.config file,

<system.webServer>
   ….
   <security>
     <requestFiltering>
       …
       <verbs>
         …
       </verbs>
       <fileExtensions>
             <remove fileExtension=".mdb" />
       </fileExtensions>
     </requestFiltering>
   </security>
  ……
</system.webServer>

{Step 2 & 3 after jump}

Continue reading Allow MS Access *.mdb Files for Upload and Download