ACC2000: System Fields Remain After You Clear Replicable Property Check Box (212888)


The information in this article applies to:

  • Microsoft Access 2000
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.
Modification Type:MinorLast Reviewed:7/16/2004
Keywords:kbbug kbpending KB212888
©2004 Microsoft Corporation. All rights reserved.