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

Article ID: 209730 - 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).

Expand all | Collapse all

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.

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"

Properties

Article ID: 209730 - Last Review: June 24, 2004 - Revision: 2.0
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbhowto kbinterop kbusage KB209730
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top