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

Access 2000 Delete multiple objects

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


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

Nov 12 '05 #2

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

P: n/a
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)
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.