ACC: Sample Function to Provide Password for Attached TablesLast reviewed: August 29, 1997Article ID: Q109829 |
The information in this article applies to:
SUMMARYAdvanced: Requires expert coding, interoperability, and multiuser skills. When you first link (attach) an external table using an ODBC driver, you have the option to store the User ID and password for the table locally. If you do not store the ID and password locally, you will be prompted later for the ID and password when you open the table (either manually or programmatically). This article describes a sample function that you can use in Microsoft Access 97, 7.0, 2.0 and 1.x to eliminate the login prompt when you open the table. 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. NOTE: Visual Basic for Applications is called Access Basic in Microsoft Access versions 1.x and 2.0. For more information about Access Basic, please refer to the "Introduction to Programming" manual in Microsoft Access version 1.x or the "Building Applications" manual in Microsoft Access version 2.0. MORE INFORMATION The following steps demonstrate how to eliminate the login prompt when you open a linked table:
|
Additional query words: attaching
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |