Knowledgebase

To use a Distinct ActiveX control in a Microsoft Access application, the application must include definitions of the actions and errors for the control. These definitions are listed in the D_*.TXT file (where * represents the control name) shipped with the ActiveX control. For example, the D_FTP.TXT file contains the definitions for the FTP ActiveX control. This file must be included either in the GLOBAL module or in the declarations section of each form that uses the control. If it is in the declarations section of each form, then remove the Global keyword from each entry in the file. Next, the Distinct ActiveX control must be added to Microsoft Access. This is accomplished by opening a form in design mode and choosing the Custom Control command from the Insert menu of Microsoft Access. Choose the Distinct ActiveX Control of interest from the list of available controls.

How to Run the Sample Programs in Microsoft Access

The following instructions show you how to run the sample application for ftp:

For Access 97:

1. Open the Microsoft Access 97 environment.
2. Select the Open Existing Data Base Option with More files… as the data base option.
3. This displays the Open dialog box. Use the browse feature to locate …\samples\access97\ftpclnt and select the ftpclnt.mdb file.
4. This brings up the sample in the environment and automatically runs it.

For Access 95:

1. Open the Microsoft Access Programming environment.
2. Click on Open in the File menu.
3. Browse for the …samples\Access97\ftpclnt folder and select the ftpclnt.mdb file.

Where to find the Access samples you need

Samples are stored in subfolders below each Access folder, that is, Access95 and Access97. Below we describe what each sample does. The folder column shows the subfolder name that contains one or more samples and the ActiveX control whose use is illustrated by the sample.

Folder	Included Samples
Firewall (Firewall ActiveX)	The daytime sample program shows you how to make a connection to a remote host through a firewall and how to retrieve the hosts reply.
FTP (FTP Client ActiveX)	This ftpclnt sample program shows you how to make a connection to the FTP server, send FTP commands and close your FTP connection. It demonstrates much of the functionality of the FTP client ActiveX control, illustrating the functions as menu items to simplify the code breakdown and allow the programmer to quickly find some sample code for a particular method or property. This sample also illustrates how to connect to an FTP server through a SOCKS firewall proxy.
Telnet (Telnet ActiveX)	The telnet sample program illustrates how to include Telnet type login capabilities into an application. It establishes a telnet connection (with the option of establishing this through a SOCKS firewall), allows you to send telnet commands and disconnects from the server. (Access97)
Windows Sockets (Windows Sockets ActiveX)	Message: This folder contains two programs recv and send that are intended to work together to illustrate how to write the client and server side of a TCP connection using the Windows Sockets control.

*Get Adobe Acrobat Reader if needed.

"Together with Distinct, we were able to offer our users an ideal soution to enabling them to connect to Yahoo! Pager, and to do so both quickly and reliably." [more]
Brian Park,
Producer of Yahoo! Pager, Yahoo! Inc.