ACC: How to Remove Linked ( Attached) Tables with a Macro

ID: Q93297

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

The TransferDatabase action is the macro equivalent of the Link Tables command (or Attach Table command in versions 1.x and 2.0). 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 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 code by using the DoCmd statement or the RunMacro method.

MORE INFORMATION

To delete a link to a linked table in Microsoft Access version 2.0, 7.0, or 97, create the following macro and save it as RemoveTable:


   Macro Name    Action
   --------------------------
   RemoveTable   DeleteObject

   RemoveTable Actions
   ---------------------------
   DeleteObject
      Object Type: Table
      Object Name: <tablename>

In code, use a DoCmd statement or the RunMacro Method to run the RemoveTable macro as follows:


   DoCmd.RunMacro "RemoveTable" ' In Microsoft Access 7.0 and 97

   DoCmd RunMacro "RemoveTable" ' In Microsoft Access version 2.0

To delete a link to a linked table in Microsoft Access version 1.x, create the following macro and save it as RemoveTable:


   Macro Name   Action
   -------------------------
   RemoveTable  SelectObject
                DoMenuItem

   RemoveTable Actions
   ---------------------------
   SelectObject
      Object Type: Table
      Object Name: <tablename>
      In Database Window: Yes
   DoMenuItem
      Menu Bar: Database
      Menu Name: Edit
      Command: Delete

Additional query words: unattach

Keywords : kbinterop kbusage McrHowto
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbhowto