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,

             <remove fileExtension=".mdb" />

{Step 2 & 3 after jump}

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