ms Access: Odbc: Insert Statement Error

[naghme]

Hello,

I try to input some data into MS Access dababase via php/odbc.
During the INSERT statement execution I got the following:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation
must use an updateable query., SQL state S1000 in SQLExecDirect

Does it imply that somehow I need to move to last record and then insert
data?

BTW, I can perform SELECT statement easy.

I attached some code below. Thank you in advance.

$conn = odbc_connect("SURVEY", "user", "pass" );

,,,, skip,,,,,,

/*--- to insert data --------*/
$sql_input="INSERT INTO ContInfo (FirstName, MiddleName)
VALUES('$FIRSTNAME','$LASTNAME')";
$query_input=odbc_exec($conn, $sql_input);

any idea?

thank you

naghmeh

[waldemar]

Have you checked (write) permissions (like in the .mdw)?

Also, I read somewhere else, you might also want to have a look at the file attributes of the database file. (http://www.phpbuilder.com/board/showthread.php?threadid=61349)