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.
  • Breadrumbs:

  • Microsoft OLE DB Provider for ODBC Drivers error '80004005' (Read and Write access to database)

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    14
  • Date Created
    Wednesday, September 29, 2010
  • Last Updated
    Wednesday, November 17, 2010
  • This Article Has been Viewed
    2510 times
  • Short Desc
    When using your computer to develop and design data driven websites using Access or Excel, you may run into the error of not able to write the information to the data source.
  • Details
    This will show you how to setup your system to allow the IUSER_MACHINE-NAME & IWAM_MACHINE-NAME access to your data source for read and write access.
  • Recreate Issue
    The error message that you may receive if you do not have Read/Write access to the database is:

     
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
  • Resolve Issue
    To correct this issue, perform the following steps.

    Go to the folder that you have your site in
    Right click on the Folder
    (I usually do the whole wwwroot folder on my developing machine)

    When you Right Click, go to [Properties]
    Click on the [Security] Tab.
    Click on the [Add] Button
    Click on the [Advanced] Button
    Click on the [Find Now] Button

    Scroll through the list until your find something that looks like this
    IUSR_MACHINE-NAME <-- The MACHINE-NAME (Will be the actual name of your computer)
    IWAM_MACHINE-NAME <-- The MACHINE-NAME (Will be the actual name of your computer)
    Click on the Item.
    Click [OK]
    Click [OK] Again
    Give it [Write] Access.
    Click [Apply] then [OK]



    --------
    Related Articles
    View Error Pages instead of 500 Error«
    Windows XP Folder Option does not have Security Tab«

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles