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

The information in this article applies to:

Microsoft Access 2000

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).

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"

Modification Type:	Major	Last Reviewed:	6/24/2004
Keywords:	kbhowto kbinterop kbusage KB209730