MS-Access and Delete function

[RushiShroff]

In my code

<%
SQLDelete=&quot;delete from m_account where Account_Id=&quot;& pAccount_Id &&quot;&quot;
		Response.Write SQLDelete
		'Response.End
		objConn.Execute SQLDelete
		SQLDelete=&quot;delete from t_leads where Lead_Account_Id=&quot;& pAccount_Id &&quot;&quot;
		objConn.Execute SQLDelete
		SQLDelete=&quot;delete from t_prospects where Prospect_Account_Id=&quot;& pAccount_Id &&quot;&quot;
		objConn.Execute SQLDelete
		SQLDelete=&quot;delete from m_contact where Contact_Account_Id=&quot;& pAccount_Id &&quot;&quot;
		objConn.Execute SQLDelete
%>

As seen again and again statement is executed.
Is there a way in access to execute all staements at one Go ?
I know that is possible in SQL server but Access Jet doesnt support Transactions.Right ?? Rushi Shroff Rushi@emqube.com
"Life is beautiful."