Solved

MS Access is it Master db or Replica

Posted on 2013-12-16
4
354 Views
Last Modified: 2014-01-21
I have master database (ver. 2000 ) and  I created replica from  that master  database .

I need fast and simple way to know which one is master and which one is replica
0
Comment
Question by:Taras
  • 2
  • 2
4 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
This MSFT Support article shows how:

http://support.microsoft.com/KB/210224

Essentially, you compare the DesignMasterID of the database to the ReplicaID. If those two don't match, then it's not a DesignMaster.

Note this article indicates that you must have a reference to DAO 3.6, but with newer versions of Access (2007+) you don't have to do this.
0
 

Author Closing Comment

by:Taras
Comment Utility
Thanks
0
 
LVL 84
Comment Utility
Curious as to the B grade. The answer was exactly what you were after, and pointed you to a document on the MSFT website.

What more could I have done to earn an A grade???
0
 

Author Comment

by:Taras
Comment Utility
It is just proper good link pointer, it is not much of your personal impute, that is the only reason.
And number of points is significant to compensate that B.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Let’s list some of the technologies that enable smooth teleworking. 
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now