[AccessD] Create object

It's possible that it is really a type of MDI app.  Just like when you open
up IE several times and one crashes, they all die.

Bobby 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Monday, November 20, 2006 2:36 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Create object

Well... I can open multiple instances manually.

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 Jim Lawrence
Sent: Monday, November 20, 2006 12:26 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Create object

Hi John:

The problem would appear to be with 3D-FTP which is designed to only open as
a single instance, per computer....

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Monday, November 20, 2006 4:01 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Create object

I am trying to open multiple instances of 3DFTP and assign each instance to
a different class instance inside of Access.  When I use the syntax:
 
'
'In class header
'
Private mFtpXObj As Object ' FtpXObj

    '
    'In init function
    '
    'Start 3D-FTP loading, if not already running
    Set mFtpXObj = CreateObject("FTP.API")

The first class instance correctly opens 3DFTP but the second class instance
does not, it simply gets a pointer to the already opened 3DFTP instance.
 
AFAIK I can't use the NEW() syntax since I don't have early binding, IOW I
don't have a clue what FTP.API actually is and therefore can't reference it
in Access.  According to the help file, CreateObject is supposed to open a
new instance of the object anyway so I really should be able to do this.
 
Any thoughts?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com