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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 555
  • Last Modified:

Find Design Master from replica db

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
Taras
Asked:
Taras
1 Solution
 
GrahamMandenoCommented:
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
 
TarasAuthor Commented:
Thanks a lot
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now