title: Simulate Multi-Threading in MS Access (VBA)
body: <p>I wrote a VBA script that runs in an Access database. The script looks up values on various tables and assigns an attribute to a main table based on the combination of values. </p>
  
  <p>The script works as intended, however, I am working with millions of records so it takes an unacceptably long time.</p>
  
  <p>I would like to break the process up into smaller parts and run the script concurrently on separate threads.</p>
  
  <p>Before I start attempting to build a solution, I would like to know:</p>
  
  <ol>
  <li>Based on your experience, would this increase performance? Or would the process take just as long?</li>
  <li>I am looking at using Powershell or VBScript to accomplish this. Any obstacles to look out for?</li>
  </ol>
  
  <p>Please Note: Due to the client this will run on, I have to use Access for the backend and if I use Powershell it will have to be version 1.0.</p>
  
  <p>I know these are very vague questions but any feedback based on prior experience is appreciated. Thanks</p>