?
Solved

Find Design Master from replica db

Posted on 2014-01-21
2
Medium Priority
?
577 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
2 Comments
 
LVL 20

Accepted Solution

by:
GrahamMandeno earned 2000 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

588 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