Match Case ? -----Original Message----- From: francesco@xxxxxxxxxxxxxxxxxx [mailto:francesco@xxxxxxxxxxxxxxxxxx] Sent: Sunday, May 02, 2004 09:19 To: php-db@xxxxxxxxxxxxx Subject: - Delete records in an Access DB Hi all, I have this problem: I want to delete records in an Access DB. I use this code: $query="DELETE FROM Test_Table WHERE name='franco';"; // the connection parameters $path="d:/inetpub/webs/my_site/mdb-database/" ; $db_name="test.mdb" ; $dsource=$path.$db_name ; $cn_string="Provider=Microsoft.Jet.OLEDB.4.0;" ; $cn_string.="Data Source=$dsource;" ; // connection $cn=new COM("ADODB.Connection"); $cn->open($cn_string); // object Recordset and send query by Open() metod $rs=new COM("ADODB.Recordset") ; $rs->open($query,$cn) ; // clean Recordset object $rs->Release() ; $rs=null ; /* close connection */ $cn->Close() ; $cn->Release() ; $cn=null ; but I have this error message: Fatal error: Call to undefined function: open() in D:\Inetpub\webs\metagenonlinecom\canc.php on line 11 Where is the problem? Is this the correct way to delete records from an Access DB? If this is a bad tecnic, can you suggest me what is the correct way? Thanks in advance to all. (The server where this script run is a Microsoft server). Francesco -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
