like summary,

conn.execute($sqlstm) failed for adding, updating and deleting sqlstament against microsoft access (ver. 97) i haven't try it in office access 2000.

my test
======
i get two computer(A and B), with same php.ini file,
using the same php script.

comp A is installled with php 4.2.2 while comp B is installed with php 4.2.3

after setup, i run the script, comp A can execute the sql statement i gave without problem... while comp B can only
perform sql statement (SELECT * FROM TABLENAME)
UPDATE, INSERT INTO and DELETE failed for comp B which is using php 4.2.3

i post the following problem already in the php forum
please go there to get the script i test.

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10209715


sincerely,
Jimson Chang