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.
Open File Explorer and navigate to the folder containing the Microsoft Access database.
Right-click the folder and select Properties.
Select the Security tab and click Edit.
Click Add to bring up the object selection dialog.
Type
IIS AppPool\YourAppPoolName(replaceYourAppPoolNamewith the actual name of your application's pool, such asIIS AppPool\DefaultAppPool) and click OK.Select the newly added user in the list.
Under Permissions, check the box for Modify. This ensures the application can both read and write to the file.
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:
Open File Explorer and navigate to the folder containing the Microsoft Access database.
Right-click the folder and select Properties.
Select the Security tab and click Edit.
Click Add.
Type
IIS_IUSRSand click OK.Select IIS_IUSRS in the list.
Under Permissions, check the box for Modify.
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
.accdbor.mdbfile.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.
