Deleting Tables, Forms, Reports etc. using code

[Geraint]

Hi,

Sounds like a strange thing to want to do but I'd like to write a utility
that deletes all tables (linked and local to database), forms, reports,
queries, macro's and modules but without removing any access system tables.
I've figured out that you need to use the "drop" command for tables but I'm
stuck on removing the others. Any help would be gratefully received.

Thanks,

Geraint

 

[Allen Browne]

Programmatically deleting all my tables does not sound like a very friendly
activity.

Remind us again why you need to do this?

 

[Geraint]

Thats great thanks. It often is easier to create a new .mdb but I've had
several occasions of corruption when importing data into a brand new
databases whereas maintaining a copy of the original database has not caused
corruption.

How would you go about deleting other objects such as forms and reports?