Using VBA with SQL Syntax -- Drop Table- A List of Tables

In Access Query, using SQL view

Drop Table Table

Now how do use on query to Del Table1 and Table2?

Or could I write this in VBA Private Sub?
Who is Participating?
Rey Obrero (Capricorn1)Commented:

currentdb.execute "drop table table1"

currentdb.execute "drop table table2"
ca1358Author Commented:
Thank you!!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.