Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 263171 - Last Review: January 27, 2007 - Revision: 3.1
Objects are removed when you convert partial replicas from Access 97 to Access 2000
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).
On This Page
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
-
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=176628/EN-US/
)
ACC97: Microsoft Access Partial Replica Wizard Available in Download Center
-
Open Access 2000 and convert PartialTest.mdb to an Access 2000 database.
-
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.
-
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.
-
Synchronize PartialTest.mdb with Replica of PartialTest.mdb. The Access objects in Replica of PartialTest.mdb are now replicated objects.
-
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.
APPLIES TO
- Microsoft Access 2000 Standard Edition
- Microsoft Access 97 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
Pham Thi Nguyet Anh
- phamthinguyet.anh NOSPAM-AT-NOSPAM vbl.com.vn
|
Report As Irrelevant
|
| Written:
1/20/2006 1:40 AM |
|
|
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please