Results 1 to 3 of 3

Thread: Run many large update queries in the right order one at a time possible?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2005
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Run many large update queries in the right order one at a time possible?

    My database is 4 million records and when I import the new data every week it's a mess because the source people are idiots.

    SOOOO, I created a long list of update queries that find the things that should not be there and eliminates them. Each query takes about 90 seconds to run - there are over 20 of them.

    Can I make a stored procedure or macro that would run each one one at a time in order so I don't need to sit there and click the button on the next query? (it takes an hour to run all of them).

  2. #2
    Board Regular
    Join Date
    Dec 2009
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Run many large update queries in the right order one at a time possible?

    You absolutely can do that.

    fast foward to 3:40 in the below video
    https://www.youtube.com/watch?v=WPBYxh4WuXE
    Last edited by =ODIN=; Aug 20th, 2019 at 09:43 PM.
    My favorite Excel Add-in:= Nutilities

  3. #3
    Board Regular
    Join Date
    May 2013
    Posts
    654
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Run many large update queries in the right order one at a time possible?

    Yes, as the video shows.
    That is about the only use I make of macroes :D
    Office 2007
    Access novice. Sometimes trying to give something back

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •