Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS Access is it Master db or Replica

Posted on 2013-12-16
4
Medium Priority
?
387 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 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1500 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 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???
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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

WARNING:   If you follow the instructions here, you will wipe out your VTP and VLAN configurations.  Make sure you have backed up your switch!!! I recently had some issues with a few low-end Cisco routers (RV325) and I opened a case with Cisco TA…
Make the most of your online learning experience.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
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: …

688 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