error odbc

[Anon]

When i use insert query with odbc, i 've error :
"INSERT INTO calendrier ( intitule ) VALUES ('sdf')
Warning: SQL error: [Microsoft][Pilote ODBC Microsoft Access] L'opération doit utiliser une requête qui peut être mise à jour., SQL state S1000 in SQLExecDirect in ..."

why ??

[fleymingmasc]

Sorry, my French isn't up to par. Could you provide a translation of the SQL error?

[Anon]

i translate this sentense :"Warning: SQL error: [Microsoft][Pilote ODBC Microsoft Access] L'opération doit utiliser une requête qui peut être mise à jour., SQL state S1000 in SQLExecDirect in ..."

-> this operation must use a request which is update., SQL state S1000 in ..."

i can't insert or update my database but i can use select statement.
thanks

[fleymingmasc]

Hmmm... I would guess that somehow your database is read-only. According to ODBC documentation, SQL state S1000 means "General error." This may sound stupid, but make sure that the MDB file is not read-only, and make sure that PHP has proper file privileges on it to write.

[Anon]

my database isn't read only.
how can i check this privileges ?

(my php works with IIS)