ACC: How to Use Automation to List SQL Server Objects (154011)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q154011 SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article shows you how to use Automation to list the objects that
exist in a Microsoft SQL Server version 6.0 or 6.5 database.
This article assumes that you are familiar with Visual Basic for
Applications and with creating Microsoft Access applications using the
programming tools provided with Microsoft Access. For more information
about Visual Basic for Applications, please refer to your version of the
"Building Applications with Microsoft Access" manual.
REFERENCES
For more information about OLE functionality and automation, search the
Help Index for Automation, or ask the Microsoft Access 97 Office
Assistant.
For further information about the SQL Server Distributed Management Object
Model (SQL-DMO), refer to the "Programming SQL Distributed Management
Objects" manual included with your SQL Server 6.0 documentation.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto kbinterop kbProgramming KB154011 |
---|
|