SharePoint 2007: "The extension .mdb may be incorrect" How to use .mdb files?

Some customers might like to use Access files as they use Excel & Word files. But the *.mdb files are blocked by default.

You must unlock/unblock these files in different places: SharePoint Central Admin, IIS & eventually the .NET web.config file.



1. Go to Central Administration > Operations > Blocked file types

2. In a page like the image below, remove the mdb file & press OK

3. Now you can upload MDb files.

4. The problem with MDB files is that you cannot download them later on by default.

5. When trying to click of save target as in an uploaded file, you might get the following error:

the type of page you have requested is not served because it has been explicitly forbidden. The extension .mdb may be incorrect.Please review the URL below and make sure that it spelled correctly.

6. Despite the fact some articles might recommend you to:

6.1 Open IIS

6.2 Go to Properties of the website (Root) > tab Home Directory > Button Configuration

6.2 Now remove the following 'ISAPI' extensions map entry: ".mdb"

6.3. This is sometimes NOT ENOUGH!

7. Change the AS.NET web.config file:

7.1 C:\WINDOWS\Microsoft.NET\Framework\VERSION\CONFIG

7.2 Open the Web.config file, and comment the following line in the image:

<add path="*.mdb" verb="*" type="System.Web.HttpForbiddenHandler" validate="true"/>

7.3 Don't do this, if your application is using an mdb file that can end up being downloaded and therefore leaking your DB info...

Good luck!