[AccessD] Create object

I've never used it, but I may have to soon.

Is it possible to Shell (the shortcut) and FindWindow,
then get the pointer?

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 9:22 AM
Subject: Re: [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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com