Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
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).
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.
To delete a link to a linked table, create the following macro, and then save it as RemoveTable:
Action: DeleteObjectUse a DoCmd statement or the RunMacro method to run the RemoveTable macro as follows:
Object Type: Table
Object Name: MyTable