Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS Access is it Master db or Replica

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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
In this article, the configuration steps in Zabbix to monitor devices via SNMP will be discussed with some real examples on Cisco Router/Switch, Catalyst Switch, NAS Synology device.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
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 …

886 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