Microsoft KB Archive/260252

= BUG: Merge Replication to Jet 4.0 Subscribers Performs Initial Synchronization when You Select the Manual Synchronization Option =

Article ID: 260252

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q260252



BUG #: 57379 (SQLBUG_70)



SYMPTOMS
When you publish merge publications to Jet 4.0 from SQL Server with the Sync_Type property equal to &quot;none&quot; for subscriptions, the merge agent fails to honor the &quot;none&quot; 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&quot;

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'&quot;



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: jet merge replication sync none subscriber Access 2000

Keywords: kbbug kbpending KB260252

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.