Microsoft KB Archive/113831

ACC1x: SQL Pass-Through Dynamic-Link Library on MSL (1.1)

Article ID: Q113831
Creation Date: 17-APR-1994
Revision Date: 24-APR-1997 The information in this article applies to:

Microsoft Access versions 1.0, 1.1

SUMMARY

The SQL pass-through dynamic-link library (DLL) provides SQL support beyond 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 local remote joins, linked tables do not support such functionality as executing row-returning stored procedures, remote DDL, and back-end-specific SQL. The MSASP110.DLL file gives the Access Basic programmer programmatic access to these capabilities.

 ~ SPT110.EXE (size: 67324 bytes) 
              is available for download from the Microsoft Software
   Library. It contains the following files:

   DEMOSPT.MDB     A sample application using the SPT DLL
   MSASP110.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 SPT110.EXE file

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

Keywords : kbfile Softlib
Version : 1.0 1.1
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.