MS Access is it Master db or Replica

Posted on 2013-12-16
Medium Priority
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
Question by:Taras
  • 2
  • 2
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1500 total points
ID: 39721867
This MSFT Support article shows how:


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.

Author Closing Comment

ID: 39798169
LVL 85
ID: 39798539
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???

Author Comment

ID: 39798605
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.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Unable to change the program that handles the scan event from a network attached Canon/Brother printer/scanner. This means you'll always have to choose which program handles this action, e.g. ControlCenter4 (in the case of a Brother).
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

597 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