Removing or Deleting an Access Table

[edemeht]

How can I remove or delete and access table once I have established an open connection to the database?

 

[BGrego]

You can use this code, where <table> is the name of the table that you want to delete


Dim strSQL as String
strSQL = &quot;DROP TABLE <table>;&quot;
DoCmd.RunSQL strSQL