CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.

Knowledge Base

Share With Friends ^{(Updated 6-8-2010)}

Article ID:
197
Date Created
Sunday, January 20, 2013
Last Updated
Sunday, January 20, 2013
This Article Has been Viewed
1498 times
Short Desc
Microsoft Access Database, must have write permissions on the folder, in order to insert or update the database.
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 updateable query.
/Populate.asp, line 19
Recreate Issue
To recreate this issue.

When you are working with a database, and you do not have the proper permissions set, for the database folder.
You will experience this issue, rather you are on a Server or a Workstation Computer, running IIS.
Resolve Issue
To resolve this issue:

Perform the following:
Browse to the location of your database folder.
[Right Click] on the Folder, of which contains your database.
Choose [Properties]
Choose [Security] tab
Click the [Add] Button
Click [Advanced...]
Click [Find Now]
Scroll down and choose the following
[IUSR_<machineName>] and [IWAM_<machineName>]
(Where <machineName> will be the name of your server)
Click [OK], then [OK] once more.
Now, give both users, [Write] Permissions, by putting a check in the Box.
Click [Apply] then [OK]

All Topics