PRB: Merge Replication to Jet 4.0 Subscribers May Fail During Process of Applying the Initial Snapshot (299314)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft Access 2000
This article was previously published under Q299314

SYMPTOMS

Merge replication to Jet 4.0 subscribers may fail during the process of applying the initial snapshot, with the following errors reported in the output file for the merge agent:
Category:AGENT
Source: MS.Jet.4.0
Number: -1507
Message: Could not find field ''.
Repl Agent Status: 3
Disconnecting from OLE DB 'JetTest'
Percent Complete:0
Syntax error in CHECK constraint clause
Repl Agent Status:6
Percent Complete:0
Category:NULL
Source:Microsoft JET Database Engine
Number:-573443523
Message:Syntax error in Check constraint clause.
Repl Agent Status:3
These errors may be reported by the merge agent when it tries to apply schema changes, create indexes, or apply check constraints on the subscriber during the initial snapshot process.

CAUSE

This problem is usually caused by an incorrect version of the Microsoft Replication provider for Jet (Msrpjt40.dll) on the SQL Server 2000 publisher. The correct version for this DLL for SQL Server 2000 (RTM version 8.00.194) is 4.10.4320.0.

WORKAROUND

You can work around this problem in the following ways:
  • If there is a version mismatch for the above DLL, rename the wrong version of the DLL file, copy the correct version of the DLL from the SQL Server 2000 CD, and then reregister the new DLL by using the Regsvr32 utility.
  • Reinstalling MDAC 2.6 on the SQL Server 2000 publisher should also avoid this merge behavior by correcting any DLL mismatch.

    WARNING: Do not install MDAC 2.6 on SQL Server 6.5 or SQL Server 7.0 clusters.
Modification Type:MinorLast Reviewed:7/14/2004
Keywords:kbprb KB299314
©2004 Microsoft Corporation. All rights reserved.