Delete Queries, Forms, Reports And Modules

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin - 19 Jan 2006 02:24 GMT

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

Thanks!

Reply to this Message

Alex Dybenko - 19 Jan 2006 05:28 GMT

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

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

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

Reply to this Message