[AccessD] Create object

Well, that's a good thought, but I can manually click the 3DFTP hotlink and
it opens multiple times.  Further I can log in to my ftp site with one
instance and an insurer's site with another.  That would indicate that 3DFTP
itself can have multiple instances open at the same time.

I am trying to keep this as simple as possible.  I have written a class that
opens 3DFTP, grabs a pointer and passes through functionality that the API
exposes. It would be nice to be able to instantiate my class more than once,
downloading data from one site, uploading to another.  As we all know, some
sites are faster than others.  If I do this stuff serially, I potentially
waste bandwidth on slow ftp sites that could be used to transfer files in a
second instance of 3DFTP.

Unfortunately as things sit, if a 3DFTP instance is open, my class grabs a
pointer to it.  If I instantiate my class a second time, the second instance
grabs a pointer to the already open 3DFTP instance and starts manipulating
it.  Not exactly what I would like to happen.  

I am writing modules to grab files from insurance companies, unencrypt them
and load the data into tables, displaying the loaded data in a tab of a form
on the user's Access application.  There are multiple insurance companies
that I need to do this for.  Each has their own ftp site and their own file
structure, the data goes into their own table (at least initially) and are
possibly displayed on their own tab.  Additionally I have to upload data
back to the insurance company's FTP site.  These downloads / uploads will
likely be scheduled for the middle of the night but it would still be useful
if I could do them all simultaneously.  

Because of the differences between the files, the encryption etc., my
intention was to have a module / class for each insurer, using my
(standardized) 3DFTP class to do the transfer grunt work.

AFAIK, one instance of 3DFTP can queue files to transfer up/down, but they
all go to the same ftp site.  In my case I need to do up/down to multiple
ftp sites.  It would be disastrous if a second instance of MY CLASS grabbed
an existing instance of 3DFTP which was hard at work, took it over, logged
in to another site and started transferring data.  Or even worse had a queue
of files destined for one FTP site suddenly being sent to someone else's FTP
site.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R Mattys
Sent: Monday, November 20, 2006 8:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Create object

Thought ...

It may be that since this thing is multi-threaded, you can only create one
instance by design.

So, you might look at creating one of their vbs plug-ins to pass more
connections to it or something ...

Michael R. Mattys
A MapPoint Developer
www.mattysconsulting.com

----- Original Message -----
From: "JWColby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Monday, November 20, 2006 8:16 AM
Subject: Re: [AccessD] Create object


> Well basically because this is the smartest bunch of folks I know, and 
> this
> is a VBA question.  It is specifically trying to open 3DFTP but the 
> question
> would be the same for opening Excel, Word etc.  I assume that they would
> react the same way.
>
> I will look at that resource though.
>
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com