Here what I do to modify an MAccess Database with ODBC where I have a table well formated:
Code --->
$connect = odbc_connect("emos_web.mdb","","");
$query = "INSERT INTO table VALUES ('1','value 1')";
$result = odbc_exec($connect, $query);
Result --->
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect
PLEASE HELP ME, the connection to database is OK for all SELECT things but can't alter the ddb!
Code --->
$connect = odbc_connect("emos_web.mdb","","");
$query = "INSERT INTO table VALUES ('1','value 1')";
$result = odbc_exec($connect, $query);
Result --->
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect
PLEASE HELP ME, the connection to database is OK for all SELECT things but can't alter the ddb!