Removing User Tables

See Also

If you no longer want to include a table in the table hierarchy, you can remove it. When Access Workflow Designer removes a table from the hierarchy, the table itself is not deleted from the database.

If the table you try to remove has a workflow process or a publication based on it, you receive a message prompting you to remove these related objects from the team solution as well. If you remove the related objects, Access Workflow Designer deletes those objects from the database.

To remove a table from the hierarchy

1. In the Access Workflow Designer, expand the Tables node in the Object List. To see the detail or lookup tables, expand the main table nodes.
   
   
2. Select a table in the Object List, and then on the Edit menu, click Remove <table type> Table.

   -or-

   Right-click a table in the Object List, and click Remove <table type> Table on the shortcut menu.

3. If there are dependent objects, such as detail and lookup tables and workflow or publication objects, you are prompted to remove these objects.
   
   
4. Click Yes.

After making database schema changes, you must re-create any existing offline publications. For details, see Re-creating an Offline Publication.