Deleting Tables, Forms, Reports etc. using code

  • Thread starter Thread starter Geraint
  • Start date Start date
G

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
 
Programmatically deleting all my tables does not sound like a very friendly
activity.

Remind us again why you need to do this?
 
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?
 
Back
Top