Error: Operation must use an updateable query.

[Teucca]

Hi. I have very simple ASP-site with one Access database where I want to allow everyone to insert data. It works fine with my computer. But when some other computer tries to insert some data, comes this error:

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/ruoka/tallenna_lisaa.asp, line 31

Is it something conserning file writing rights? And if it is, how can I change it so anyone can insert data in it?


p.s. site is located on my computer (I have installed IIS)

[Nicodemas]

You must give the IUSR_<MachineName> account write access to the folder containing the database, because it has to create a temporary .ldb file when updating the database.