Deleting a table from database

[jimmykwh]

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

[Gary.Lowe]

This should do it


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