Solved

MS Access is it Master db or Replica

Posted on 2013-12-16
4
369 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
[X]
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
  • 2
  • 2
4 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 39721867
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
ID: 39798169
Thanks
0
 
LVL 84
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???
0
 

Author Comment

by:Taras
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.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

735 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