Open Design Master

[Guest]

I have beginning experience in access. I was trying to create a copy of a
database I created since we have the same type of information stored for two
separate divisions of the company. well, this is where I think I messed up -
I created a replication of the database I had spent hours working on. Now I
am trying to change some minor things within the database and I get the
following notice. :

You cant modify the design of Day Info at a replica. Design changes to
replicated objects can only be made at the design master. Do you want to open
it as a read-only?

well of course I don't but it doesn't give me an option of doing anything
else, and I can't seem to locate the Design Master. Do I have any options?

 

[gls858]

I have beginning experience in access. I was trying to create a copy of a
database I created since we have the same type of information stored for two
separate divisions of the company. well, this is where I think I messed up -
I created a replication of the database I had spent hours working on. Now I
am trying to change some minor things within the database and I get the
following notice. :

You cant modify the design of Day Info at a replica. Design changes to
replicated objects can only be made at the design master. Do you want to open
it as a read-only?

well of course I don't but it doesn't give me an option of doing anything
else, and I can't seem to locate the Design Master. Do I have any options?

When you say "design master" do you mean you can't find the original database?

gls858

 

[Van T. Dinh]

I don't have a replicated database at the moment but IIRC, from the replica,
you can use the Menu command Tools / Replication / Synchronize Now ... and
the Dialog will show the full path to the Design Master.

In addition, you can also re-create the Design Master from the Replica using
the Menu command Tools / Replication / Recover Design Master ...

 

[John Spencer]

Ouch!
What you really wanted to do was to copy the original database in the
Windows Explorer. What you have done is to make a replicated database and a
master database. Replication is designed to keep the data synchronized
between the Master and all the replicated copies.

I use replication with a bunch of notebook computers that are used to gather
data off-site and then regularly have the data synchronized with the master
database.

If you have a backup that was created before you instituted replication,
then you can go back to that. If you have no backup, I would suggest that
you can try the Michael Kaplan's utility at the following URL to
Un-Replicate your database.

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7

 

[Guest]

Mr Spencer,

I have been synchronizing the team's databases who are currently offsite to
the Design Master. For some reason, it didn't work yesterday. I can see in
their replicas that there should be records with the 17th and now the 18th's
date and when I synch up it says it's successfull yet when I open the Design
Master back up that data from those dates is not there.

Unfortunately, I do not understand the "front-end" references that people
are talking about. All I know enough to explain is that I simply use the
tools/synchronize menu and it has worked for the last 5 months.

Hope you can help?

 

[John Spencer]

Sorry, I can't help. I will be offline for the next two weeks.

You might make sure that you are sychronizing to the master database. The
only thing I can think of is that you are not synchronizing to the database
you believe you are. Check the pathname of the database you are
synchronizing to.

 

[David W. Fenton]

I have been synchronizing the team's databases who are currently
offsite to the Design Master. For some reason, it didn't work
yesterday. I can see in their replicas that there should be
records with the 17th and now the 18th's date and when I synch up
it says it's successfull yet when I open the Design Master back up
that data from those dates is not there.

Unfortunately, I do not understand the "front-end" references that
people are talking about. All I know enough to explain is that I
simply use the tools/synchronize menu and it has worked for the
last 5 months.

Splitting an Access application is a very basic thing that should
happen with every multi-user database.

Consider how MS Word works. Every user has it installed on his or
her workstation, even if they are sharing Word documents on a server
somewhere.

Likewise, in an Access application, the
queries/forms/reports/macros/modules are your "application" (i.e.,
like the Word application files) that you run to edit your data file
(an MDB with the data tables in it and nothing else).

So, you'd use two MDB files, one with tables only (the back end) and
one with the queries/forms/etc. (the front end application), and
have links from the front end to the back end. There will be only
one copy of the back end, stored on your server. But every
workstation will have a copy of the front end.

Tony Toews has written a nice step-by-step explanation of all of
this and provides a nice little updater program to make distributing
updates to the front end easy:

http://www.granite.ab.ca/access/splitapp/index.htm

 

[David W. Fenton]

In addition, you can also re-create the Design Master from the
Replica using the Menu command Tools / Replication / Recover
Design Master ...

But you should only do that when you are certain you've lost the DM.