problem with SQL statement

[luc83]

Hi everyone

The problem a have here would more go in a SQL forum but since there is no, I've decide to put it here..

I'm using a access database with IIS. When I want to insert something in the database with the INSERT INTO statement, here is the error it send me:


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/asp/cours/Ajouter_valider.asp, line 225


I've check the setting of IIS and it all seems good. I could post my code if you want to but I really dont think my code's got error.

thanks..
Luc

[luc83]

I have the write access and still it doesnt works...

[luc83]

OK I just found it...
Thanks a lot..

I had to Disable "Anonymous acces" ..

[luc83]

In IIS right-click your virtual directory or any that you want...
then properties... click the Directory security tab...
then, click the first button labeled "edit"
you got it right there " Anonymous access"

I dont know why but its the first time I had to go change that setting.

Luc
oh, by the way, an SQL forum would be cool!:)