Microsoft KB Archive/263171

= Objects are removed when you convert partial replicas from Access 97 to Access 2000 =

Article ID: 263171

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition
 * Microsoft Access 97 Standard Edition

-



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.



Steps to Reproduce Behavior
 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. Convert the PartialTest.mdb to an Access 97 Design Master. Create a full replica named Replica of PartialTest.mdb. 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. Open Access 2000 and convert PartialTest.mdb to an Access 2000 database.</li> 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.</li> 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.</li> Synchronize PartialTest.mdb with Replica of PartialTest.mdb. The Access objects in Replica of PartialTest.mdb are now replicated objects.</li> Synchronize PartialTest.mdb with Partial Replica of PartialTest.mdb.</li></ol>

Note that all the objects, except tables and queries, have been deleted from the partial replica.

Additional query words: pra ACC2000

Keywords: kbbug kbnofix KB263171

-

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

© Microsoft Corporation. All rights reserved.