Skip to main content

How to Grant an IIS Application Write Access to a Microsoft Access Database

This article explains how to configure Internet Information Services (IIS) permissions to allow a web application to write data to a Microsoft Access database. This is required when a web application hosted on a Windows Server needs to modify or...

This article explains how to configure Internet Information Services (IIS) permissions to allow a web application to write data to a Microsoft Access database. This is required when a web application hosted on a Windows Server needs to modify or update records within an .mdb or .accdb file.

Before you begin

You will need:

  • Administrator access to the Windows Server

  • The specific file path to the Microsoft Access database (e.g., C:\inetpub\wwwroot\data\database.accdb)

  • The name of the IIS Application Pool running the website

Granting File System Permissions

To allow the web application to write to the database, you must grant the specific IIS identity permission to the folder containing the database file.

  1. Open File Explorer and navigate to the folder containing the Microsoft Access database.

  2. Right-click the folder and select Properties.

  3. Select the Security tab and click Edit.

  4. Click Add to bring up the object selection dialog.

  5. Type IIS AppPool\YourAppPoolName (replace YourAppPoolName with the actual name of your application's pool, such as IIS AppPool\DefaultAppPool) and click OK.

  6. Select the newly added user in the list.

  7. Under Permissions, check the box for Modify. This ensures the application can both read and write to the file.

  8. Click OK on the Security tab, then click OK on the Properties window.

Granting IIS Permissions

If you prefer to grant access to the broader IIS identity (common in multi-app environments), follow these steps:

  1. Open File Explorer and navigate to the folder containing the Microsoft Access database.

  2. Right-click the folder and select Properties.

  3. Select the Security tab and click Edit.

  4. Click Add.

  5. Type IIS_IUSRS and click OK.

  6. Select IIS_IUSRS in the list.

  7. Under Permissions, check the box for Modify.

  8. Click OK on both windows to apply the changes.

Confirm the result

  • The web application should now successfully perform "Write" actions (such as submitting a form or updating a record) in the Microsoft Access database.

  • You can verify this by attempting to submit a form through the website that interacts with the database.

Troubleshooting

"Access Denied" or "Read-Only" Errors

If the application still cannot write to the database after following the steps above:

  • Verify that the file itself is not marked as "Read-only" in the file properties.

  • Ensure that the folder path is correct and that the application is pointing to the exact location of the .accdb or .mdb file.

  • Restart the IIS Application Pool via the IIS Manager to refresh the permissions.

Limitations

  • This procedure only grants file system permissions. It does not resolve issues related to incorrect connection strings or database-level permissions.

  • Microsoft Access is not recommended for multi-user web applications due to its file-locking mechanism; for high-traffic websites, a migration to Microsoft SQL Server is recommended.

Did this answer your question?