i have a very simple MS Access database connected using ODBC
$conn = odbc_pconnect("sample", "", "");
$res = odbc_exec($conn, "select * from member");
odbc_result_all($res);
i can execute the above select statement without any problem
and it returns;
id name email
1 anthony anthony@eeproduction.com
2 tester tester@test.com
but i have problem execute insert statements like
insert into member(id, name, email) values
(3, 'john', 'john@smith')
also i have problem execute update statements like
update member set name = 'john' where name = 'anthony'
they all give me this error;
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in e:\inetpub\wwwroot\php_experiement\db\dbTester.php on line 15
where line 15 is:
$res = odbc_exec($conn, "update member set name = 'john' where name = 'anthony'");
is there something fundamantally wrong with my sql statement or i'm using the wrong method??
any ideas??