Solution to “Operation must use an updateable query” Exception when writing to an Access Database from ASP.NET

Could be a couple of things:

1. The file is marked as read-only.  Right click on file, uncheck “read only”.
2. The application pool identity doesn’t have write permissions to the folder that contains the MDB. Find the identity of the application pool (using IIS) and (using Windows Explorer) give that identity (usually Network Service) write permissions to the folder.'
3. Check this KB for more possible reasons: http://support.microsoft.com/kb/175168

Jon Gallant

dev lead @ microsoft

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS