What is MIME type "application/vnd.ms-access"?

A MIME type is a string that tells browsers and other tools how to handle a particular kind of file.

application/vnd.ms-access is the MIME type for files created by Microsoft Access. It signals that a file contains a structured database used for storing tables, queries, forms, and reports.

Files using this MIME type include the database file format MDB and the snapshot format SNP that may contain preconfigured views of data.

Database Storage: Holds relational data and supports data organization.
Data Management: Enables CRUD operations and report generation.
Office Integration: Works with other Microsoft Office applications for linked workflows.

This MIME type helps operating systems and web servers recognize and handle the file appropriately. For more details, see the IANA media type entry.

Associated file extensions

.mdb, .snp

Usage Examples

HTTP Header

When serving content with this MIME type, set the Content-Type header:


    Content-Type: application/vnd.ms-access

HTML

In HTML, you can specify the MIME type in various elements:


    <a href="file.dat" type="application/vnd.ms-access">Download file</a>

Server-side (Node.js)

Setting the Content-Type header in Node.js:


    const http = require('http');    
    
    http.createServer((req, res) => {    
      res.setHeader('Content-Type', 'application/vnd.ms-access');    
      res.end('Content here');    
    }).listen(3000);

Associated file extensions

.mdb, .snp

FAQs

How do I configure Apache or Nginx to serve MDB files?

To serve Microsoft Access files correctly, add the directive AddType application/vnd.ms-access .mdb to your Apache .htaccess file. For Nginx, add application/vnd.ms-access mdb; inside the types { } block in your mime.types configuration file.

Can web browsers open application/vnd.ms-access files directly?

No, web browsers like Chrome, Firefox, and Edge cannot natively render .mdb or .snp files. Because these files require the specific database engine found in Microsoft Access, browsers will force a file download instead of displaying the content inline.

Are there security risks associated with this MIME type?

Yes. Access databases can contain Visual Basic for Applications (VBA) macros, which are capable of executing malicious code on a user's machine. It is crucial to scan any downloaded application/vnd.ms-access file for malware before opening it.

Why does IIS return a 404 error when accessing an MDB file?

Microsoft IIS often blocks the serving of Access databases by default to prevent users from downloading sensitive data or configuration files. You may need to explicitly add the MIME type application/vnd.ms-access for the extension .mdb in the MIME Types feature of the IIS Manager.

Does this MIME type cover newer .accdb files?

Generally, no. The application/vnd.ms-access type is historically associated with the older binary .mdb format (Access 2003 and earlier). The newer XML-based format, usually seen with the .accdb extension, typically uses the MIME type application/msaccess.

What is the SNP file extension associated with this type?

The .snp extension stands for "Snapshot." It is a legacy file format used to save a static copy of a Microsoft Access report, allowing users to view the report layout and data without having access to the live database. It uses the same MIME type but requires the Snapshot Viewer utility.

General FAQ

What is a MIME type?

A MIME (Multipurpose Internet Mail Extensions) type is a standard that indicates the nature and format of a document, file, or assortment of bytes. MIME types are defined and standardized in IETF's RFC 6838.

MIME types are important because they help browsers and servers understand how to process a file. When a browser receives a file from a server, it uses the MIME type to determine how to display or handle the content, whether it's an image to display, a PDF to open in a viewer, or a video to play.

MIME types consist of a type and a subtype, separated by a slash (e.g., text/html, image/jpeg, application/pdf). Some MIME types also include optional parameters.

How do I find the MIME type for a file?

You can check the file extension or use a file identification tool such as file --mime-type on the command line. Many programming languages also provide libraries to detect MIME types.

Why are multiple MIME types listed for one extension?

Different applications and historical conventions may use alternative MIME identifiers for the same kind of file. Showing them all helps ensure compatibility across systems.