KB Issue
Microsoft Access Database must have write permissions on the folder to insert or update the database.
Issue Details
When you try to connect to an Access database to update or insert data, without the proper permissions given to the folder, you will not be able to send data to the database.
Microsoft JET Database Engine error '80004005'
Operation must use an updatable query.
/Populate.asp, line 19
Recreate Issue
While working with an Access database, and you do not have the proper permissions set for the database folder.
You will experience this issue whether you are on a Server or a Workstation Computer running IIS.
Resolve Issue
Perform the following:
Browse to the location of your database folder.
  • [Right Click] on the folder that contains your database.
  • Choose [Properties]
  • Choose [Security] tab
  • Click the [Add] Button
  • Click [Advanced]
  • Click [Find Now]
  • Scroll down and choose the followingIUSR <machineName>
    Copy
    Search Site
    Search Google
    and IWAM <machineName>
    Copy
    Search Site
    Search Google
    (Where <machineName>
    Copy
    Search Site
    Search Google
    will be the name of your server)
  • Click [OK], then [OK] once more.
  • Now, give both users [Write] Permissions by checking the Box.
  • Click [Apply] then [OK]