Modifying an Offline Publication

See Also

After creating an offline publication, you can modify the offline publication using the Offline Publication pane in the Access Workflow Designer. You can add or remove database objects, define filters to limit the data a user can take offline, and specify permissions for publications.

Important   While modifying an offline publication, it is recommended you drop the publication, so it is not available to offline users. This prevents offline users from attempting to synchronize while you are making changes to the publication. For details, see Removing Publications from the Server.

To modify existing offline publications

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 for that publication.
   
   
4. Right-click the publication, and select Drop SQL Publication to drop it from the server. For details, see Removing Publications from the Server.

   Note   Dropping the publication prevents users who have the publication offline from synchronizing while the publication is being modified.

5. In the Offline Publication pane, make changes to the offline publication.

   To	See
   Add or remove the main user tables that are copied to the local database	Specifying Main Tables for an Offline Publication
   Create filters that determine which rows are copied to the local database	Filtering Data for an Offline Publication
   Designate the roles that can take a publication offline	Defining Permissions for Offline Publications
   Designate additional database objects that are available or restricted from the offline copy of the database	Specifying Database Objects for Offline Use

   
   
6. Save your changes, and then click Re-create SQL Publication to update the publication.

Be sure to re-create the publication any time you perform any of the following changes:

• Removing a main, detail, or lookup user table that is included in the publication.
  
  
• Adding, modifying, or removing a workflow process.
  
  
• Changing any offline publication options.
  
  
• Changing schema or security of an existing solution that contains publications.

If a user has a publication offline while you are making changes to its online counterpart, when that user returns online, a notification message is displayed indicating the publication has changed. The user must synchronize the team solution to update the publication. For details about re-creating publications, see Re-creating an Offline Publication.

For an example of how to implement offline support, see Offline Support in the Issue Tracking Solution.