Microsoft KB Archive/212888

= ACC2000: System Fields Remain After You Clear Replicable Property Check Box =

Article ID: 212888

Article Last Modified on 7/16/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q212888



This article applies only to a Microsoft Access database (.mdb).

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



SYMPTOMS
A table that was replicated continues to have a replication field even after you have set the Replicable property of the table to No.



RESOLUTION
You cannot simply open the table in Design view and delete the replication field. Instead, you must create a new table from a make-table query, and then exclude the replication field. For an example of how to do so, follow these steps:
 * 1) Create a new query, and add the table that has the replication field.
 * 2) Add all the fields to the query design grid, except for the s_GUID field.
 * 3) On the Query menu, click Make-Table Query.
 * 4) In the Table Name box, type a new table name, and then click OK.
 * 5) On the Query menu, click Run.
 * 6) Click Yes when you are prompted that you are about to paste rows into a new table.
 * 7) Close and do not save the query. Open the newly created table and note that the s_GUID field no longer appears.

NOTE: When you run a make-table query to create a new table, the table does not necessarily inherit all the properties from the table on which the query is based.

For additional information about how to copy all table properties with a make-table query, click the article number below to view the article in the Microsoft Knowledge Base:

209225 ACC2000: Make-Table Query Does Not Copy All Table Properties



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



MORE INFORMATION
In a replicated Access database, you can change the Replicable property of a table in order to remove that table from the set of replicable objects. However, the system fields for replication will remain in the table after the Replicable property is cleared.

Steps to Reproduce the Behavior

 * 1) Start Access 2000 and when you are prompted to open a file, click Cancel.
 * 2) On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
 * 3) In the Database to Compact From dialog box, select the sample database Northwind.mdb.
 * 4) In the Compact Database Into dialog box, type DM.mdb in the File name box, and then click Save.
 * 5) Open DM.mdb, and on the Tools menu, point to Replication, and then click Create Replica.
 * 6) Click Yes when you are prompted to close the database. Click No when you are prompted to create a backup. Click OK to create Replica of DM.mdb, and then click OK when you are prompted that Access has converted DM.mdb to a Design Master and Replica.
 * 7) When the Design Master has been reopened, click Relationships on the Tools menu.
 * 8) Delete the relationship between Employees and Orders, and then click Yes when you are prompted to verify the change. Close the Relationships window.
 * 9) On the Tools Menu, click Options, and on the View tab, click to select the System objects check box. Click OK.
 * 10) Right-click the Employees table, and then click Properties.
 * 11) Click to clear the Replicable check box, and then click OK.
 * 12) Open the Employees table in Design view. Note that the replication field s_GUID is still in the table.

Additional query words: false pra untrue

Keywords: kbbug kbpending KB212888

-

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

© Microsoft Corporation. All rights reserved.