Solved

Find Design Master from replica db

Posted on 2014-01-21
2
538 Views
Last Modified: 2014-01-21
I have MS access 2002 replica database file named “Parts” located  on a server folder .
I need to find where is master design file of this replica database.
Problem is that  there are a number of  databases and there is no  good documentation where they are located.
I need help with finding where is design master of this particular replica “Parts” database.
Is there way to find path where is design master or what the name it has.

Any idea?
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 Comments
 
LVL 20

Accepted Solution

by:
GrahamMandeno earned 500 total points
ID: 39798871
Hi Taras

Open the replica and display the Immediate window (ctrl-G)

Type:
?CurrentDb.DesignMasterID <enter>
A GUID will be displayed.

Type:
DoCmd.OpenTable "MSysReplicas" <enter>
The replicas table will open.

Scroll across to the ReplicaID column and find your DesignMasterID GUID (expand the column width if necessary.

The MachineName/Pathname and/or UNCPathname fields in the same row will point you to the design master.

Best wishes,
Graham Mandeno [Access MVP 1996-2014]
0
 

Author Closing Comment

by:Taras
ID: 39798985
Thanks a lot
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article is in regards to the Cisco QSFP-4SFP10G-CU1M cables, which are designed to uplink/downlink 40GB ports to 10GB SFP ports. I recently experienced this and found very little configuration documentation on how these are supposed to be confi…
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

615 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