Sorry I forget to mentioned. The 3 functions accessing and updating the same table but each function has its own data to update. For instance the total records is 300,000 then: Function# 1 will update 1-100,000 Function# 2 will update 101,000-200,000 Function# 3 will update 201,000-300,000
my main objective is to speed up the process 3x. Yesterday, I tried when I click run, 3 access application will open and automatically runs each function which does the trick but I want to run it locally because opening another instance of access eats a lot of memory. I tried in VB so 3 small *.exe files opens and hide and also does the trick but still I want to run it locally or in one access application. Any tips would be appreciated... TIA, George -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Lonnie Johnson Sent: Saturday, October 21, 2006 11:26 PM To: [email protected] Subject: Re: [ms_access] Run 3 Function at the same time If you are updating records you can not write to a single record from three different sources at the same time. Why do you need to update the recordset with three different updates at the same time? Can you tell us more about what gets updated? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: George Oro <[EMAIL PROTECTED]> To: YG Access Dev <[email protected]>; YG Access <[email protected]> Sent: Saturday, October 21, 2006 3:12:58 AM Subject: [ms_access] Run 3 Function at the same time I have a 3 identical functions that loops & updates a recordset and I want them to run at the same time. What I did now, I created 3 identical forms and and set on timer to run the function. So basically: Form1 will run Function1 Form2 will run Function2 From3 will run Function3 All forms opens at the same time but the functions runs one at a time. Any tips would be greatly appreciated. TIA, George [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
