Microsoft ACCESS pb: "INSERT INTO table"

admin

Administrator
Staff member
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!
 
Back
Top