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

SUMMARY

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