[AccessD] Create object

JWColby jwcolby at colbyconsulting.com
Mon Nov 20 06:01:24 CST 2006


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
 



More information about the AccessD mailing list