Selecting and deleting multiple database objects

[sayetta]

Would love to hear from anyone who knows how to delete multiple objects (for example, tables) from the database window. I've got over 100 table links and sometimes need to delete all or most of them.

Thanks!

 

[Aivars]

Hi, sayetta!

See at thread705-101285
I hope there you'll find answers to your question.

Aivars
LOL My summer holidays will start next week! Hurrah!

 

[Tzokas]

Well sayetta,

try this code in a backup of your database.

***This deletes all of your tables in your project***


Do While DCount("[Name]", "MSysObjects", "[Type]=1 And [Name] NOT Like ""MSYS*""&quot > 0
DoCmd.DeleteObject acTable, DFirst("[Name]", "MSysObjects", "[Type]=1 And [Name] NOT Like ""MSYS*""&quot
Loop

or see at faq181-690 for selecting other objects

In case of tables,if you need to delete some relationships before see also at faq181-837

Good Luck