Microsoft KB Archive/209730

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

Article ID: 209730

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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:

Use a DoCmd statement or the RunMacro method to run the RemoveTable macro as follows: DoCmd.RunMacro "RemoveTable"

Additional query words: unattach

Keywords: kbhowto kbinterop kbusage KB209730

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.