How to delete a table in Access?

[Thomas Halsvik]

How do one delete a table in Access?
CurrentDB.OpenRecordset("myTable").Delete ?

[Jimbob]

it's been a long while since i've done it, but from memory you could try: -

CurrentDb.Execute "DROP TABLE <Tablename>"

[CtrlAltDel]

you could do a docmd.deleteobject "<mytable>" i think

or else you could write a query that deletes the table

i think i have one hold on
.
.
.
looking
.
.
.
sql = "DROP TABLE [mytable]"
myDatabase.execute sql

thats the easiest and fastest way to do it.