Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: How to Remove Linked ( Attached) Tables Using a Macro

ACC2000: How to Remove Linked ( Attached) Tables Using a Macro

View products that this article applies to.

This article was previously published under Q209730
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

↑ Back to the top

Summary

The TransferDatabase action is the macro equivalent of the Link Tables command. However, Microsoft Access does not have an action to delete a link to a linked (attached) table. To remove a linked table from the Database window, select the table in the Database window, and then press the DELETE key. You can also create a macro to delete a link to a linked table, or you can call the action from Visual Basic code by using the DoCmd statement or the RunMacro method.

↑ Back to the top

More information

To delete a link to a linked table, create the following macro, and then save it as RemoveTable:
Action: DeleteObject
Object Type: Table
Object Name: MyTable
Use a DoCmd statement or the RunMacro method to run the RemoveTable macro as follows: 
DoCmd.RunMacro "RemoveTable"

↑ Back to the top

Keywords: KB209730, kbusage, kbinterop, kbhowto

↑ Back to the top

Article Info
Article ID : 209730
Revision : 2
Created on : 6/24/2004
Published on : 6/24/2004
Exists online : False
Views : 311