[RESOLVED] Updateable query, Access & IIS

[John_SC]

I am trying to develop an application that updates a table in Access. I currently have the table in my own C:\Inetpub\wwwroot directory, running Windows XP. The table has only one field (test) which is a text variable, with no primary key.

I can query the table without problems. But when I try to insert, I get the common "Operation must use an updateable query" error. This is often due to rights problems, but I have it in my own Windows directory. Any help would be appreciated.

[vksingh24]

One reason might be the read-only properties in the ms-access.
make sure you have the writing permission with the Access. Just right click and check the Read Only Property.

[John_SC]

The problem turned out to be that Windows (at least in XP Pro) allows you to set different permissions to the files. If you open the file explorer, and riight click on the database, then properties, then the security tab, it has different properties for the administrator and everyone else. The write property for everyone else was set to false. Setting it to true resolved this problelm.