From: [EMAIL PROTECTED] Operating system: w2k PHP version: 4.0.5 PHP Bug Type: ODBC related Bug description: cannot insert data in msaccess hello. my script is : ----------------------------- <? /* connect database */ $dsn = "nawa_dsn"; $user = ""; $pw = ""; $conn = odbc_connect($dsn,$user,$pw); $sql = "insert into TB_Login (UserID,Name) values ('002','Somphob')"; /* check for errors */ if (!odbc_exec($conn,$sql)) { /* error */ echo "Error"; } else { echo "OK!"; } /* close connection */ odbc_close($conn); ?> ----------------------------- and result is : ----------------------------- Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:\inetpub\wwwroot\customer\save.php on line 12 Error ----------------------------- please tell me. thank. -- Edit Bug report at: http://bugs.php.net/?id=11571&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]