With the Demo Version, when I try to login using the supplied User ID and Registration Code, I get the following message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
Please advise what needs to be done.

This problem deals with not having write permissions set on the database for internet user. It may occur when you use Windows NT or Windows2000 with NTFS file system to install InstaIntranet.

To solve this error you must enable write permissions the directory where the Access database resides for the IUSER_<severname> Account. Your server administrator is the only one who can do this. The "Operation must use an updateable query" is an NT (Windows2000) Permissions problem. This error occurs when the person browsing the site doesn't have sufficient permissions to complete the necessary transaction to the database. 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 (typically Inetpub/wwwroot/Data & Inetpub/wwwroot/File).  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.

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

-----------------------------------------------------------------------------------------------------------------[back]