Delete Queries, Forms, Reports And Modules

M

Martin

How can all the queries, forms, reports and modules be programatically
deleted from an external database?

Thanks!
 
A

Alex Dybenko

Hi,
you can open this database in access via automation (set
oAcc=createObject..)

then go through all forms using oAcc.CurrentProject.AllForms to get forms
names
and delete using oAcc.docmd.DeleteObject
same for modules and repots and queries
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can I save a sql statement generated by a search form? 1
Uncompiled Form/Report Module after LoadFromText 0
Excel 2003 - VBA to get a list of Module names in the project 4
Creating a Chart on form from selected data in query. 0
VBA Project Deleted 5
import data question 1
Module??? 1

Top