[AccessD] Create New DB + link table check (Was: Major Performance issue)

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/


More information about the AccessD mailing list