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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding New records in multiple tables 2
Delete Query: Could not delete from specified tables 0
Query in Access cannot be updated 1
query substitution 4
Append Queries and Autonumbers 2
Relationships 1
Create a indeterminate relationship in access using sql 2
Delete Query Help 2

Back
Top