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.