Microsoft KB Archive/113831

{|
 * width="100%"|

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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''