[dba-VB] threading

Shamil Salakhetdinov shamil at smsconsulting.spb.ru
Wed Dec 9 14:59:21 CST 2009

Hi John --

Why not have several (FE) applications if they are so independent? - all
developed within one VS solution but as separate (WinForms) projects sharing
the same (set of) class library(-ies)?


-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, December 09, 2009 10:14 PM
Subject: [dba-VB] threading

As mentioned in previous emails, I am developing an application to manage
all of the tasks for the 
DBFH.  This includes Backing up databases, creating orders, transferring
data between an external 
app etc.  I am trying to determine how to thread this app such that if I
start a process exporting 
data to Accuzip, I could have another process importing data from Accuzip,
and also be working on an 

As things currently stand, each of these tasks is a project and each project
has its own forms and 
classes, and anything else necessary for that task.  I really do want to be
able to do multiple 
things like this at the same time.  Exporting data to Accuzip can take
overnight, and actually 
consists of an export and a matching import process.  It makes perfect sense
(to me) to have threads 
doing this kind of thing, and allow me to go back to the main application
and do something else.

But at what level would I use a thread?  Would I use a thread to open the
form that performs the AZ 
process?  This would allow me to get that started and immediately go back to
the main app and open 
another form (using a new thread?) to start processing an order.

Or would the form open and the button on the form start a thread that
executes the process?  If a 
form starts a thread, that allows the user (me) to do other things in that
form potentially changing 
to a new directory or selecting a different database.  Do you disable all
controls on a form when a 
thread starts?  I never had to think about this in VBA and it is all rather

John W. Colby
dba-VB mailing list
dba-VB at databaseadvisors.com


__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4674 (20091209) __________

The message was checked by ESET NOD32 Antivirus.


More information about the dba-VB mailing list