Multiple delete queries in one query...

  • Thread starter Thread starter Daryl
  • Start date Start date
D

Daryl

Hi
Is there any way that you can run multiple queries in access as you can in
say server.

delete * from tblOne
delete * from tblTwo

I would like to delete the contents of every table in a given access2000
database.

daryl
 
Hi,

such as:


Public Sub mySub()
With CurrentProject.Connection
.Execute "DELETE * FROM tableOne"
.Execute "DELETE * FROM tableTwo"
End With
End Sub



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top