Modifying an Offline Publication
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
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
Open your solution in the Access Workflow Designer. For details, see Opening your Solution in the Access Workflow Designer.
In the Object List, expand Offline Publications by clicking the plus (+) sign.
Select an offline publication to display the Offline Publication pane for that publication.
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.
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 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.