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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record insert/delete anomaly 0
Deleting Tables 4
How to export table from outlook into ms access table? 0
Delete using join statement 4
Deleting tables 9
Word VBA for deleting Selected Row 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Deleting a Table if It Exists 5

Back
Top