HOME PURCHASE FEATURES SYSTEM REQ. PREVIEW SUPPORT INSTALLATION FAQ'S

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

Need more information on this error, try the following MS Knowledgebase Article.

Note:  For Security reasons it is highly recommended that you move the database outside your web structure.  This makes it impossible for anyone to hack into your database and provides the highest level of security.  Alternatively, if you are using FrontPage you can keep the database in the web structure and simply turn off browsing for that directory.

If you receive this error when attempting to insert a new record or update an existing record, then the permissions are not set correctly for the Anonymous User Account.  If you are not an administrator on the web server, you will need to ask your Web Hosting Provider to make this change for you.

To fix this, use File Manager to find the folder holding your database.  Note that this is done in file manager and not the Microsoft Management Console.  Once the folder is located, right mouse-click on the folder and select Properties.

The following dialog box appears.  Select the Security folder.  Next, click the Permissions button.

Next, select the Anonymous User Account and set the Permissions to Change (RWXD). In this case the Anonymous User is Everyone, however the name varies from one system to another.  Click OK when finished.

AdComplete.com, LLC    4536 Grove Park Dr.    Tallahassee Florida,  32311
Phone 407-551-0777 

Copyright (c) 2001-2006 AdComplete.com, LLC All Rights Reserved