Page 1 of 1

PHP with ODBC Connection (MS Access)

Posted: Fri Oct 17, 2003 7:51 am
by desmondlk
Hi All,

Currently, I am exploring the ODBC connection (MS Access) with PHP. I executed the below PHP script.

$Username = "admin";
$SessionID = "Ux99ulB5p8PnMJWl3ZBs";

$Query1 = "INSERT INTO login ".
"(Username, SessionID) ".
"VALUES ('$Username', '$SessionID')";

$result1 = odbc_do($cn, $Query1);

However, it thrown out the below error message.

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

May I know whether my script is incorrect? Please help.

Thanks in advance.

Regards,
Desmond.

Posted: Fri Oct 17, 2003 8:01 am
by markl999
I don't use MS Access myself but i believe this is related to permissions. Make sure the 'admin' user has write permissions on 'login'