Removing Publications from the Server

See Also

When removing a publication from the server you have two options. You can delete the publication, or you can drop it. If you delete a publication, the design is completely removed from the server and the Access Workflow Designer. To create a publication, you must start from the beginning, and any users that have the solution offline cannot ever synchronize their data.

If you drop the publication, the publication is removed from SQL Server, but your design is not deleted from the Access Workflow Designer. This is a good option if you want to modify a publication and must prevent users from synchronizing. Users may not synchronize until the publication is re-created.

To drop a publication from SQL Server

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. Right-click an offline publication, and select Drop SQL Publication.
   
   
4. Click Yes.
   
   
5. The publication is removed from SQL Server, but the design remains in the Access Workflow Designer.

Once the publication is dropped, you can make any changes necessary and then select Re-create SQL Publication to make the publication available on SQL Server again. For details, see Re-creating an Offline Publication.

To delete a publication permanently

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. Right-click an offline publication, and select Delete Publication.
   
   
4. Click OK.

The publication is removed from SQL Server and from the Access Workflow Designer.