ACC: How to Relink Back-End Tables with Common Dialog Control (181076)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q181076 SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article shows you how to use the Common Dialog control to refresh
linked tables in your database. The Common Dialog control is available with
the Microsoft Office 97 Developer Edition Tools or the Microsoft Access Developer's Toolkit version 7.0. The tables being linked may reside in one or many back-end databases.
For an example of a different method to relink tables that uses Windows
application programming interface (API) functions, refer to the Developer
Solutions sample application (Solutions.mdb) included with Microsoft Access
7.0 and 97. Open the Solutions.mdb database, select "Use multiple
databases" in the "Select a Category of Examples" box, and then "Link
tables at startup" in the Select An Example box.
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 information about customizing the example for refreshing linked tables
in the Developer Solutions sample application (Solution.mdb), please see
the following article in the Microsoft Knowledge Base:
154397
ADT/ODE How to Modify RefreshTableLinks Module in Solutions.mdb
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto kbProgramming KB181076 |
---|
|