Access 2000 Delete multiple objects

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • oskar hritz
    #1

    Access 2000 Delete multiple objects

    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!
    Tags: None
    • Allen Browne
      #2
      Re: Access 2000 Delete multiple objects

      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" <oskar.hritz@sc a.com> wrote in message
      news:408e0d9c$0 $203$75868355@n ews.frii.net...[color=blue]
      > 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.[/color]


        Comment

        • oskar hritz
          #3
          Re: Access 2000 Delete multiple objects

          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!

            Comment

            • Lyle Fairfield
              #4
              Re: Access 2000 Delete multiple objects

              oskar hritz <oskar.hritz@sc a.com> wrote in news:408e4138$0 $199$75868355
              @news.frii.net:
              [color=blue]
              > However,the most primitive 3rd option (using shift) is quite quick. It
              > takes less then 1 minute so it is just perfect for me.[/color]

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

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

                Comment

                Previous template Next
                Working...