How do one delete a table in Access?
CurrentDB.OpenRecordset("myTable").Delete ?
Printable View
How do one delete a table in Access?
CurrentDB.OpenRecordset("myTable").Delete ?
it's been a long while since i've done it, but from memory you could try: -
CurrentDb.Execute "DROP TABLE <Tablename>"
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.