Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Access 2007 and 2010

Posted on 2013-01-22
3
711 Views
Last Modified: 2013-01-23
My OS is win 7 prof 64 bit.  
i have a access 2007 file which is a replica and was I think created in Win XP 32 bit.   But the users who are not familar with DBs, never sync it for a long time.  Now that I have 2010 Access, I tried to open it, and I got the error as in below.  Also since my OS is 64 bit I get an error also that to change something to 64 bit.

"This member of the replica set has exceeded the maximum number of days allowed between synchronizations and can't be synchronized with any other member of the replica set.
Delete this replica set member and create a new replica. "

Can I make this Replica the Design master, as it looks like the Design Master has been lost.  If Yes, please let me know the steps in Access 2010.  
Or is there any other solution where I can use this Replic just like a normal access database.
Thank u
0
Comment
Question by:jegajothy
3 Comments
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 150 total points
ID: 38808229
To my understanding, Access 2010 and 2013 do not support replication/synchronization.

Take a look at this article for details on converting a replica to a normal database:

http://support.microsoft.com/kb/153526
0
 
LVL 77

Accepted Solution

by:
peter57r earned 350 total points
ID: 38809264
Replicaton is still there in Access 2010.
It's a standard ribbon item for any mdb file and is part of the Database Tools ribbon.

It's a very long time since I used replication and I just can't remember whether you can recover a design master from an out-of-date replica.  But it's worth a try.
0
 

Author Closing Comment

by:jegajothy
ID: 38809933
thank u
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question