By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,566 Members | 1,811 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,566 IT Pros & Developers. It's quick & easy.

Delete all objects from database other than tables

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"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
Nov 13 '05 #2

P: n/a
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.
Nov 13 '05 #3

P: n/a
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.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.