What would be the effect in the system if 21 nos. of Access files are open
at the same time?
1 = 5 MB (MainApp.mde)
20 = 400 KB each (Run1.mde, Run2.mde - Run20.mde)
Here's my plan at the moment:
1) When I click one button to the MainApp the targeted data (eg. 20,000
records) will be exported or dump to one mdb file (TempFile.mdb) then...
2) If I click the Run button:
a) the above total targeted data will be divided and flagged into 20
categories (Flag=Run1,Run2 etc...). So basically each category will have
1000 records (20000/20).
b) after the the above process the system will open the 20 mde files
(Run1, Run2 etc..). Run1-20.mde files are linked to the TempFile table.
c) then OnLoad of Run1-20.mde files one function will run and loop and
update to the recordset.
d) After the process it will automatically exit.
So Run1.mde will loop only to those records which category or flag = Run1
Basically Run1-20 has its own 1000 records to process to avoid conflict when
updating...
I was force to run each process to a separate mde. file because of the .dll
file Im using which required to the process. I tried 20 forms but it doesn't
works because of the dll. I cannot reference it more than ones in one mde
file even i made 20 copies of the dll with different names...
My main objective is to speed up the process. So if my function now will
take 20 minutes to update the 20,000 records then by using the above
approach it will take only 1 minute.
Any input would be greatly appreciated.
TIA,
George
[Non-text portions of this message have been removed]
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/
