Specifying Main Tables for an Offline Publication

See Also

Any table that is designated as a main table can be included in an offline publication. Detail or lookup tables related to the main table are included automatically as well. When you use the Offline Publication wizard to create a new publication, you are asked to specify tables to include in your publication. You can add or remove main tables in your publication after it is created using the Tables tab in the Offline Publication pane.

When you create a publication, dependencies between objects are verified. If you remove a main table that has objects depending on it, such as views or dependent tables, you receive an error message when you try to re-create the publication. This message lists the objects with the missing references that must be addressed before creating the publication.

To manage dependencies required by the publication, use the Database Objects tab in the Offline Publication pane to add or remove them manually before attempting to re-create a publication. For details, see Specifying Database Objects for Offline Use.

Hint   It is easier to remove the entire publication and re-create it without the main table than to try to remove the main table and remove all the related objects manually.

To add or remove main tables from a publication

  1. Open your solution in the Access Workflow Designer. For details, see Opening your Solution in the Access Workflow Designer.

  2. In the Object List, expand Offline Publications by clicking the plus (+) sign.

  3. Select an offline publication to display the Offline Publication pane.

  4. In the Offline Publication pane, select the Tables tab.

  5. Select the tables you want to add to your offline publication. To remove a table, clear the box next to the table.

  6. Click Re-create SQL Publication.

    Note   If you receive a reference error message, you can either choose to stop the re-creation of the publication and remove the dependent database objects manually or continue creating the publication with the broken references. It is recommended you stop and remove these dependent objects manually rather than re-creating a publication with broken references.

  7. If necessary, click Save.