Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

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?
0
ca1358
Asked:
ca1358
1 Solution
 
Rey Obrero (Capricorn1)Commented:

currentdb.execute "drop table table1"

currentdb.execute "drop table table2"
0
 
ca1358Author Commented:
Thank you!!!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now