Search For:
Categories:
Products:
Category Navigation: Home \ Script Errors
[KB_48] - Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
SUMMARY:
You recieve this error anytime one of our scripts tries to write information to the database.

SYMPTOMS:
  • This error will appear anytime you try to write information to the database.
  • It usually appears on a newly installed copy of the script.
  • It may appear if you move the script to a different folder on your server or to a different host.


  • CAUSE:
    This error is a permission problem caused by Microsoft Access. Access needs to create a lock file (.ldb) in the folder that the database file is in... In many cases the credentials that the web server is using doesn't have the appropriate permissions to the folder the database resides in to do so.

    RESOLUTION:

    You can easily correct this problem by granting the default IIS user on your server "FULL CONTROL" over the folder that the database file resides in. 

    If you are running the script on a web hosts server you may have a utility that is part of a web based control panel that allows you to set permissions on files and folders... if so you can use that utility to correctly set the permissions on the folder.



    MORE INFORMATION:

    Most web hosts already have a "database" or "db" folder setup on your hosting account that already has the correct permissions set on the folder.  If so you should move your database file to that folder and change the connection string in the db.asp file to reflect that new location.


    Categories
    Script Errors ▪

    Applies To
    • aspWebCalendar ALL
    • aspWebAlbum ALL
    • aspWebHeadlines ALL
    • aspWebDocuments ALL
    • aspWebMail ALL
    • aspWebContacts ALL
    • aspWebLinks ALL

    Article Details
    Article ID: KB_48
    Date Added: May 27, 2006
    Last Update: May 27, 2006
    User Rating:  (9309 Ratings) (9309 Ratings) (9309 Ratings) (9309 Ratings) (9309 Ratings)
    Total Views: 10700

    Article Actions
    Print Article
    Email Article
    Add To Favorites

    This KnowledgeBase is powered by aspWebKnowledgeBase, an upcoming product from Full Revolution, Inc.

      Legal Information  |  Privacy Information


    Site Contents Copyright 2000 - 2005 Full Revolution, Inc.  All rights reserved.