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
