Find All tables in a Database and delete them?

  • Thread starter Thread starter RocketDude
  • Start date Start date
R

RocketDude

Hi,

How do I find all of the tables that exist in the current database, and then
delete them using VBA?

TIA,
 
you can use TableDefs collection to get all tabledef objects, which are
represent tables.
but please note that it also contains system tables MSys*, which you can't
delete.

also you can make a query on MSysobjects table
 
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

Rename database Object from another Database 2
How to change Pivot Table external data source (MS Access Database)by VBA 0
Delete tables in another database via VBA 7
delete record from external database 6
how to delete a table if it exists 2
Access Table Import with VBA 2
Finding a table in a table collection... 3
Record insert/delete anomaly 0

Back
Top