Objects are removed when you convert partial replicas from Access 97 to Access 2000 (263171)


The information in this article applies to:

  • Microsoft Access 2000
  • Microsoft Access 97
This article was previously published under Q263171
Moderate: Requires basic macro, coding, and interoperability skills.

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

SYMPTOMS

You convert a Microsoft Access 97 partial replica to Access 2000. Then you synchronize the Access 97 partial replica with a converted full replica or with Design Master. All the database objects are removed from the converted partial replica except tables and queries.

RESOLUTION

Create new partial replicas in Access 2000 from the converted Design Master.

STATUS

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

MORE INFORMATION

Steps to Reproduce Behavior

  1. In Access 97, create a new database named PartialTest.mdb that has one table, one query, one form, one report, one macro, and one module.
  2. Convert the PartialTest.mdb to an Access 97 Design Master.
  3. Create a full replica named Replica of PartialTest.mdb.
  4. Use the Partial Replication Wizard to create a partial replica named Partial Replica of PartialTest.mdb. If you do not have the Partial Replication Wizard, please refer to the following Knowledge Base article:

    176628 ACC97: Microsoft Access Partial Replica Wizard Available in Download Center

    Note that, at this point, both full and partial replicas contain all Access objects.
  5. Open Access 2000 and convert PartialTest.mdb to an Access 2000 database.
  6. Convert Replica of PartialTest.mdb to an Access 2000 database. Note that Access objects, except tables and queries, appear as local objects in the converted replica. This is expected behavior before synchronizing this replica.
  7. Convert Partial Replica of PartialTest.mdb to Access 2000. Note that Access objects, except tables and queries, appear as local objects in the converted replica. This is expected behavior before synchronizing this replica.
  8. Synchronize PartialTest.mdb with Replica of PartialTest.mdb. The Access objects in Replica of PartialTest.mdb are now replicated objects.
  9. Synchronize PartialTest.mdb with Partial Replica of PartialTest.mdb.
Note that all the objects, except tables and queries, have been deleted from the partial replica.
Modification Type:MajorLast Reviewed:11/19/2004
Keywords:kbbug kbnofix KB263171
©2004 Microsoft Corporation. All rights reserved.