SYMPTOMS
When you publish merge publications to Jet 4.0 from SQL Server with the
Sync_Type property equal to "none" for subscriptions, the merge agent fails to honor the "none" value. Instead, the merge agent creates tables and populates the data again.
For example, when a subscription to a jet subscriber is created with the following stored procedure, the merge agent creates tables on the jet database and populates them:
sp_addsubscriber @subscriber = N'jetpublication', @type = 3,
@login = N'admin', @password = N'', @security_mode = 0,
@frequency_type = 64, @frequency_interval = 1,
@frequency_relative_interval = 2, @frequency_recurrence_factor = 0,
@frequency_subday = 8, @frequency_subday_interval = 1,
@active_start_date = 0, @active_end_date = 0,
@active_start_time_of_day = 0, @active_end_time_of_day = 235900,
@description = N'OLE DB Provider for Jet'
exec sp_changesubscriber_schedule @subscriber = N'jetpublication',
@agent_type = 1, @active_end_date = 0"
sp_addmergesubscription @publication = N'jetpublication',
@subscriber = N'jetpublication', @subscriber_db = N'DSN',
@subscription_type = N'push', @subscriber_type = N'local',
@subscription_priority = 0.000000, @sync_type = N'none',
@frequency_type = 4, @frequency_interval = 1,
@frequency_relative_interval = 1, @frequency_recurrence_factor = 0,
@frequency_subday = 8, @frequency_subday_interval = 1,
@active_start_date = 0, @active_end_date = 0,
@active_start_time_of_day = 0, @active_end_time_of_day = 235959,
@enabled_for_syncmgr = N'false'"