Microsoft KB Archive/113495

INF: SQL Pass-Through Dynamic Link Library on MSL (1.0)

PSS ID Number: Q113495 Article last modified on 06-13-1995

1.00

WINDOWS

= SUMMARY =

This article describes the SQL Pass-Through dynamic-link library (DLL) file available on the Microsoft Software Library. This file provides SQL pass- through support for Microsoft Access.

= MORE INFORMATION =

The SQL Pass-Through DLL provides additional SQL support to that provided by Microsoft Access linked tables. While linked tables cover a wide range of requirements for transparent access to remote data, including binding Microsoft Access form, report, and query objects directly to remote tables and views, and performing remote joins, linked tables do not support such functionality as returning stored procedures, remote DDL, and back-end specific SQL commands.

The SPT.DLL file gives the Access Basic programmer access to these capabilities.

You can download SPT100.EXE as a self-extracting file from the Microsoft Software Library on the following services:


 * CompuServe GO MSL Search for SPT100.EXE Display results and download
 * Microsoft Download Service (MSDL) Dial (206) 936-6735 to connect to MSDL Download SPT100.EXE
 * Internet (anonymous FTP) ftp ftp.microsoft.com Change to the softlib/mslfiles directory Get SPT100.EXE

= MORE INFORMATION =

The SPT100.EXE file contains the following files:

DEMOSPT.MDB A sample application using the SPT DLL SPT.DLL A Windows DLL containing the SQL Pass-Through functions SPTDESCR.TXT Documentation for installing and using the SPT DLL README.TXT Describes the contents of the SPT100.EXE file

Additional reference words: 1.00 KBCategory: kbusage kbfile KBSubcategory: Softlib ============================================================================= Copyright Microsoft Corporation 1995.