Delete Queries, Forms, Reports And Modules

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks!
 
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
 
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

Record insert/delete anomaly 0
import data question 1
How to list the names of forms and reports of an .mdb database by VBA 2
Access Access Report Works on One Machine but not Another 3
Trying to delete tables, forms, queries, etc. in an external datab 4
VBA Project Deleted 2
Access 2003 db window 0
Why Does My Button Code Copy To "General" Object Window From "[My Button Name]" Objec 0

Back
Top