#32041 [Opn]: Deleteing From a MS Access Database using PHP

ID: 32041 User updated by: mark dot horwell at uhns dot nhs dot uk Reported By: mark dot horwell at uhns dot nhs dot uk Status: Open Bug Type: ODBC related Operating System: Windows XP PHP Version: 4.3.10 New Comment: Managed to solve the problem, it was an issue with file permissions, where only set to read only on the database. Thanks Previous Comments: ------------------------------------------------------------------------ [2005-02-21 09:55:42] mark dot horwell at uhns dot nhs dot uk Description: ------------ When ever i try to delete a record with a MS access database I get the following error message Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables., SQL state S1000 in SQLExecDirect in C:\Estates Info System\admin\Delete_Site.php on line 13 I know ther no problem with the sql statment, not sure what to do. I am using PHP, IIS and MS access Please Help Reproduce code: --------------- <? $connect = odbc_connect ("Information_System","root",""); $query = "DELETE FROM Site WHERE(((Site.[Site Code])='076'))"; odbc_exec($connect, $query); ?> Expected result: ---------------- Record with key 076 whould be deleted but is not Actual result: -------------- Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables., SQL state S1000 in SQLExecDirect in C:\Estates Info System\admin\Delete_Site.php on line 13 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=32041&edit=1