Deleting Tables

[PITBULLCJR]

Is there any way to delete a table? If there is please let me know and maybe tryt o explain it a little bit for me thanks!!

[Clunietp]

what database?

[JasonGS]

You can do it with the SQL statement "DROP TABLE Table1", ADO example...

Dim adoConn As New ADODB.Connection
' Assuming a connection is made to your DB here...
adoConn.Execute "DROP TABLE Table1"

[Chris]

This DROP TABLE sql statement also can use in the DAO object.