delete table

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

How does one delete the existence of a table using VBA
code. Note: not delete the records in a table. I mean
delete the whole thing from existence.

any help is once again appreciated. Thanks
 
Good morning Craig

Try the DeleteObject action or DeleteObject method as shown in MS Access Help

Hope this helps

Maurice St-Cyr
Micro Systems Consultants, Inc
 
you can execute a DDL query ...

CurrentDB.Execute "DROP Table MyTable", dbFailOnError

Steve
 
Back
Top