Microsoft KB Archive/172164

= ACC97: Data in OLE Object or Memo Field Missing from Replica =

Article ID: 172164

Article Last Modified on 1/20/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q172164



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
After you synchronize a replica, the data in a Memo field or OLE Object field in a member of the replica set is missing. Also, a conflict error is generated.



CAUSE
During synchronization, an error occurred, which prevented the transfer of data in a Memo field or OLE Object field to one of the replicas.



RESOLUTION
To correct the conflict error and restore the data to the Memo or OLE object field, follow these steps:


 * 1) Open the replica that contains the conflict table. In the Resolve Replications Conflicts dialog box, click Resolve Conflicts. This button is not enabled unless you have opened the replica containing the conflict table.
 * 2) Note that the existing record contains data in the OLE Object or Memo field, and that the Conflict record does not contain data in that field. Click Keep Existing Record.
 * 3) When prompted to confirm that you want to keep the existing record, click Yes. When you receive a message that you've successfully resolved all the conflicts, click OK.
 * 4) In the Resolve Replication Conflicts dialog box, click Close.
 * 5) Synchronize with the other member of the replica set.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97. This problem no longer occurs in Microsoft Access 97 Service Release 1.

NOTE: Stand-alone Microsoft Access 97 Service Release 1 is not currently available, but you can update your copy of Microsoft Access 97 to Service Release 1 by downloading Microsoft Office Service Release 1 from Microsoft's Web site at:

http://office.microsoft.com/en-us/assistance/HA010449921033.aspx



Steps to Reproduce Problem
 Start Microsoft Access and open a new, blank database.  Create a new table named tblTest:

      Table: tblTest -      Field Name: ID         Data Type: Number Field Size: Long integer Indexed: Yes (No Duplicates) Field Name: Notes Data Type: Memo

Table Properties: tblTest -      PrimaryKey: ID

Close and save the table as tblTest.  Create a replica of the database.  In the Design Master, enter the following record into the tblTest table:

<pre class="fixed_text">      ID     Notes 1     test

Close the Design Master. </li>  Open the replica and enter the following record into the tblTest table:

<pre class="fixed_text">      ID     Notes 1     test </li> Synchronize with the Design Master.</li> In the Resolve Replication Conflicts dialog box, click View Data Errors. Note that the changes you requested were not successful because they would create duplicate values in the index, primary key, or relationship.</li> Close the Replication Data Errors dialog box and close the Resolve Replication Conflicts dialog box.</li> Close the replica and open the Design Master.</li> When the Resolve Replication Conflicts dialog box appears, click Close.</li>  Open the tblTest table and change the one existing record as follows:

<pre class="fixed_text">      ID     Notes 1     test </li> Close the table and synchronize with the replica. Note that there is now a replication conflict in the Design Master.</li> Close the Resolve Replication Conflicts dialog box and open the tblTest table. Note that both records contain data in the Notes field.</li> Close the Design Master and open the replica. Open the tblTest table. Note that in the second record, there is no data in the Notes field.</li></ol>

<div class="references_section">