Anytime you make schema changes that require an offline publication to be updated, you must re-create the publication using the Re-create SQL Publication option. The old publication is dropped automatically, and an updated copy is created.
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. Then, the user must synchronize the team solution to update the publication.
Note If the user has made changes to rows that have been removed from the publication, the user receives a message indicating that synchronization has failed for those rows. In this situation, the user will not be able to update the online database with changes made to those rows.
To re-create an offline publication
Note You can choose a default approach to re-creating publications. In the Access Workflow Designer, from the Tools menu, select Options. You can specify whether you want publications automatically created whenever you save changes. Creating publications may take a few minutes depending on the size of your publication.