DB crashed when running macro

[Johnny12]

I'm having a problem where after a while, when I run a certain marco, the DB will crash out and restart. I can repair/compact all I want but it will just keep crashing. The macro runs 20+ queries. But if I run each query, one by one run (never need to go past qry003), then if I run the macro again, it works just fine. I've included a screenshot of the first half of the macro. Thoughts? How do I trouble shoot? Thanks!

[June7]

Recommend converting to VBA.

[Johnny12]

Such a simple yet 100% accurate fix. Thank you!