ALL OR NOTHING: (works i.e. with MS ACCESS - ODBC) function prepare() { global $conn; $result = odbc_prepare ( $conn, "CREATE TABLE XX(test int);CRATE TABLE YY;"); if(odbc_execute($result)){echo "Everything is OK (but shouldn't!).";} else{echo "Error in the statement. Table XX should NOT be there.";} } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php