Delete all objects from database other than tables

[Ellen Manning]

Using A2K. I need syntax to delete all objects from a database other
than tables, like with a FOR...LOOP construct. I researched the
newsgroup and found suggestions to look thru Access help on
collections and containers to find examples there. I honestly cannot
find what I need so I'm either not looking in the right place or it's
just not there.

Any help or advice would be appreciated.

[Rick Brandt]

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...

Using A2K. I need syntax to delete all objects from a database other
than tables, like with a FOR...LOOP construct. I researched the
newsgroup and found suggestions to look thru Access help on
collections and containers to find examples there. I honestly cannot
find what I need so I'm either not looking in the right place or it's
just not there.

Any help or advice would be appreciated.

I can't think of any reason you would need to do this repeatedly or as a
normal function within the app. If it is a one-time deal it would be
easier to create a new blank file and import only the tables into it. Is
it because you have several files you want to do this on?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Pieter Linden]

ma**********@hotmail.com (Ellen Manning) wrote in message news:<da*************************@posting.google.c om>...

Using A2K. I need syntax to delete all objects from a database other
than tables, like with a FOR...LOOP construct. I researched the
newsgroup and found suggestions to look thru Access help on
collections and containers to find examples there. I honestly cannot
find what I need so I'm either not looking in the right place or it's
just not there.

Any help or advice would be appreciated.

Loop backwards through each container, deleting the objects. If to
try to go from 1 to Tabledefs.Count, you'll error out, because the
count will decrease as you delete objects.

[Ellen Manning]

Thank you, Pieter.

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...

ma**********@hotmail.com (Ellen Manning) wrote in message news:<da*************************@posting.google.c om>...

Using A2K. I need syntax to delete all objects from a database other
than tables, like with a FOR...LOOP construct. I researched the
newsgroup and found suggestions to look thru Access help on
collections and containers to find examples there. I honestly cannot
find what I need so I'm either not looking in the right place or it's
just not there.

Any help or advice would be appreciated.

Loop backwards through each container, deleting the objects. If to
try to go from 1 to Tabledefs.Count, you'll error out, because the
count will decrease as you delete objects.