Sad Der
accessd666 at yahoo.com
Fri Jan 23 03:44:14 CST 2004
Hi group, I've got a solution to my performance problem. Before the users start their analyses I copy the data to the local database! Copying the data takes about 45-55 seconds, calculating the data LESS THEN 2 seconds!! :-) I don't want this copied data in the original client so I want to create a new mdb. I don't have my A2KDH Enterprise Edition with me I'm asking you guys. Does anybody have a (set of) function(s) to create a DB with tables and link to it? I've searched wolfwares.com but I couldn't find any of it and this subject has to be discussed here at some point....or not? The idea is: User needs to use the Analyses tool Create new TEMP DB (duration: ?) Create tables (duration: ?) Check links (duration: ?) Copy data from BE (duration: 45-55 seconds) When user stops the MAIN application (= Analyses tool is part of the MAIN application) delete the TEMP DB. TIA Sad __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/