Access 2000 Delete multiple objects

[oskar hritz]

It may sound stupid but I have not found any person able to make
multiple deleting of objects in Access 2000. I would like for example
to delete all queries (I have 200 of them) and download them again ( a
bit advanced) from database which I use for development.

Is there anybody who knows?

It is quite an important thing for me.

Oskar

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Allen Browne]

You could loop backwards through the QueryDefs collection deleting each one.

You could create a new (blank) MDB, and import all the other objects.

You could hold down the Shift key and click Delete 200 times. (The Shift
avoids the confirmation dialog).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"oskar hritz" <os*********@sca.com> wrote in message
news:40*********************@news.frii.net...

It may sound stupid but I have not found any person able to make
multiple deleting of objects in Access 2000. I would like for example
to delete all queries (I have 200 of them) and download them again ( a
bit advanced) from database which I use for development.

[oskar hritz]

Thank you Allen,

I have no idea how to use QueryDefs and also second option is not ideal
in my case as I am linking tables from different sources.

However,the most primitive 3rd option (using shift) is quite quick. It
takes less then 1 minute so it is just perfect for me.

One more time thank you.

Oskar

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Lyle Fairfield]

oskar hritz <os*********@sca.com> wrote in news:408e4138$0$199$75868355
@news.frii.net:

However,the most primitive 3rd option (using shift) is quite quick. It
takes less then 1 minute so it is just perfect for me.

You will go blind in your old age if you do this.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)