Removing design master status

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ondine - 24 Jul 2005 23:00 GMT

Hi there

Does anyone know if it is possible to take away design master status from a
database, without moving or changing the name permanently? I have tried
renaming and then renaming back again, and the design master status comes
back.

I need to do it because the design master is currently being used for
directly entering data and is also indirectly synchronising with a laptop.
The reason for this unhappy situation is because the original design master
lost its status by being moved to a new folder (!) and the wrong file was
recovered as the DM. I would rather not change the current file (e.g. create
a new replica) because of its link with the other pc, which may not be
available when I visit the client.

I know that it is inadvisable to use the DM for entering/amending data and
synchronisation, but would also be grateful for some pointers as to why that
is the case.

Many thanks.

Ondine.

Reply to this Message

David W. Fenton - 25 Jul 2005 01:55 GMT

> Does anyone know if it is possible to take away design master
> status from a database, without moving or changing the name
[quoted text clipped - 13 lines]
> data and synchronisation, but would also be grateful for some
> pointers as to why that is the case.

Is there any reason why you can't create a new replica from the
design master, then synch with that new replica and transfer design
master status to that replica (it's a checkbox in the Access
synchronization dialog)?

I'd definitely want to get away from using the DM for editing.

I'd also recommend *not* using a file name with the word "design
master" in it. Indeed, I make all my replicas have EXACTLY THE SAME
NAME. It's their location that defines their function, from my point
of view.

The only exception I'd ever make with this would be in setting up a
replica farm.

Signature

David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Reply to this Message

Ondine - 25 Jul 2005 13:23 GMT

Thanks very much for your help - I wasn't aware that you could so easily
transfer the design master status from one file to another - forgive my
ignorance! I tried searching on the Knowledge Base and nothing came up. The
design master file will be in it's own separate folder with the same file
name.

By the way, I took your advice re the corruption problems I had with this
client and moved to Indirect Replication. That and their purchase of new
equipment seems to have solved the data corruption problem, so your help is
very much appreciated.

Ondine.

> > Does anyone know if it is possible to take away design master
> > status from a database, without moving or changing the name
[quoted text clipped - 28 lines]
> The only exception I'd ever make with this would be in setting up a
> replica farm.

Reply to this Message

David W. Fenton - 26 Jul 2005 03:06 GMT

> Thanks very much for your help - I wasn't aware that you could so
> easily transfer the design master status from one file to another
> - forgive my ignorance! I tried searching on the Knowledge Base
> and nothing came up. The design master file will be in it's own
> separate folder with the same file name.

Well, I'm glad it's easy, too, but that also means you have to be
careful with it, since it's easy to mess things up if you take the
easy way out. Your situation clearly isn't like that, but I often
worry about people who have less experience with replication. It
really is complicated and takes a while to wrap your head around the
various issues and problems involved.

> By the way, I took your advice re the corruption problems I had
> with this client and moved to Indirect Replication. That and
> their purchase of new equipment seems to have solved the data
> corruption problem, so your help is very much appreciated.

Glad to have helped! I'm also glad you didn't have too many problems
implementing it -- it's not easy to get working right.

Signature

David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Reply to this Message