Deleting a table from database

Hei dude, can u teach me how to delete a particular table from a database by stating the database name in use ans the table name to be delete. then just push the command button to execute the delete statement. so how to write the delete statement??

thanks

This should do it

Code:

---

Dim dbs As Database

        ' Modify this line to include the path to your database
        Set dbs = OpenDatabase("MyDB.mdb")

        ' Delete the table.
        dbs.Execute "DROP tblMyTable;"

        dbs.Close

---

Hope this helps