Specifying Database Objects for Offline Use

See Also

When you specify main tables to include in an offline publication, all the related detail tables, lookup tables, views, and other database objects are included automatically in your offline publication. The only time you must modify the database objects list is when you want to remove a main table from your publication. Removing a main table does not drop automatically related tables. In fact, it is possible to re-create your publication with broken references.

For example, the Issue Tracking solution might use a date column to calculate and display the age of an issue. If you exclude the table with that date column from the offline publication, your publication will not run properly.

To avoid problems with broken references, when you remove a main table and attempt to re-create a publication, you receive a warning that lists the related objects that have broken references.

If you remove a database object, test your solution to make sure the offline publication performs properly without it.

To include or exclude other database objects 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 from the list to display the Offline Publication pane.

  4. In the Offline Publication pane, select the Database Objects tab, and then select either All database objects in the solution or Only objects currently included in publication.

  5. In the object list, select the box next to objects to include them, and clear the box for objects to exclude from the publication.

  6. Select Re-create SQL Publication. When prompted to save, click Yes.

It is recommended you test your solution to verify that all objects the solution requires to work properly offline are included in the publication.