Solved

Problems with design master (replication)

Posted on 2004-09-14
14
1,149 Views
Last Modified: 2008-01-16
Hi all !

I was working in a design master located on a network. some days later, when I opened the design master, access told me that the database is just the replica. I tried to recover the design master with the build-in acccess function and got the following error message:
"The value specified is not a ReplicaID for any member in the replica set. (Error 3488)"

What went wrong and what can I do to reestablish the desgin master ???

Thanks

Andy
0
Comment
Question by:cas1
  • 7
  • 6
14 Comments
 
LVL 57
ID: 12052930
Andy,

  Sounds like the database is corrupt.  See if you can get compact/repair to run on it (you may need to use JETCOMP.EXE, a standlone compact/repair utility on Microsoft's web site).  Depending on how long it's been since you last synced, you might not wat to risk it and just deal with use the other existing members.

  Synchronize all of the replicas in your replica set to make sure that all are up to date. Then choose one of them to be the new Design Master from the Replication menu, by using Replication Manager, or from code by setting the DesignMasterID property.

  You also might want to get this for reference:

Frequently Asked Questions About Microsoft® Access 2000 Replication
http://support.microsoft.com/default.aspx?scid=kb;en-us;282977

HTH,
Jim.
0
 
LVL 4

Author Comment

by:cas1
ID: 12053473
I have now imported all tabels in a new database, deleted all relations, set all tabels to be replicated, rebuild all relations. So far, so good. Now I could make it as design master again. BUT: After copying to the network, reestablished as design master, made new replicas: After synchronizing, the same problem as before occured: The design master before now only is a replica and I get the error "The value specified is not a ReplicaID for any member in the replica set. (Error 3488)" again.

All for nothing...

I need some help immediately

Andy
0
 
LVL 57
ID: 12053583
Andy,

 <<The design master before now only is a replica and I get the error "The value specified is not a ReplicaID for any member in the replica set>>

  I'm not sure I understand this last part.  Are you saying you left the original master in the replica set?

<<I have now imported all tabels in a new database, deleted all relations, set all tabels to be replicated, rebuild all relations. So far, so good. Now I could make it as design master again>>

  You can't do that as   you've created a new replica set by doing so.  

  Out of the *existing* replicas, you need to promote one to master after syncing them.  If the original master cannot be repaired with compact/repair, then it's lost.  If it is repaired, it still looses its replicated status.  Either way, it's no longer a master.  You need to promote a new master from the remaining replicas.

Jim.

0
 
LVL 4

Author Comment

by:cas1
ID: 12053696
I don't have a remaining replica. It's deleted. I have to say that I am new to replication. Maybe I have an understanding problem. What means to create a new replica set ?

Please help

Andy
0
 
LVL 57
ID: 12053840
Andy,

<<What means to create a new replica set ? >>

  A "replica set" is a master databbase and possibly one or more replicas.  Internally, each of these databases are tagged with a ReplicaID.  This is how Access knows which set a replica is part of.

<<I don't have a remaining replica. It's deleted.>>

  I'm a bit confused then.  You said:

"I have now imported all tabels in a new database, deleted all relations, set all tabels to be replicated, rebuild all relations. So far, so good. Now I could make it as design master again. BUT: After copying to the network, reestablished as design master, made new replicas: After synchronizing, the same problem as before occured: The design master before now only is a replica and I get the error "The value specified is not a ReplicaID for any member in the replica set. (Error 3488)" again."

  So to make sure I understand, everything is new right?  Your not using anything that you had previously.  You created a new master, and created *new* replicas from that, then tried to sync and got the error?

 <<I have to say that I am new to replication.>>

  You should read through that FAQ I posted before going further.  It might clear up some things for you about how replication works and some of the "gotchas".  In fact one thing that just caught my attention is that you said you moved the master; you can't do that after replicas are created.  Might be part of your problem.  I'm not sure.  Anyway, it's worth a read.

Jim.
0
 
LVL 4

Author Comment

by:cas1
ID: 12062153
Hi, Jim,

now I have read the FAQ and some things are clearer now, some others NOT.

What I have done is the following:

The original design master is located on a network drive at the customer. If I make changes, I copy the design master to my laptop, make this as new design master (because it is a replica then only), make my changes to the tabels, copy it back to the customer's network drive and then make this on again as the design master. Maybe this causes the corruption of the database ? If this is not a good way, what is the best way to make changes "offline" ?

Another thing that is not really clear to me is: what exactly is a replica set? I understand it as a group of databases (1 design master and n replicas). BUT: When is a replica set created and how can I move a databse to another location ?

Thanks for your help

Andy
0
 
LVL 2

Expert Comment

by:grayderek
ID: 12063240
Have read the foregoing and note that you say you are working with a 'customer'

? do you have access to their network either remote or direct in their office
 - if so keep the design master on your pc and create a replica on their network - this way any remote changes can be transfered by syncronising replica's
- if not then design master/replicas is not the way to go!  you could split the dbase to frontend and backend and play around with this, but you usually have to relink tables etc (can be a nightmare but sensible if the data is large).  The way I currently do it with some clients is:-
1. Create mdb dbase
2. make mde from this
3. copy mde to client either direct or zip and email
4. after changes (bug fixes,enhancements etc)
5. copy mde from client
6. import tables from mde to mde, either delete existing tables first or delete and rename after import (all depends on the changes you make)
7. repeat from 2.
 
Hope this helps
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 4

Author Comment

by:cas1
ID: 12063361
@grayderek:

if i keep the design master on my pc, i always have to import the actual data to the tabels of the design master on my pc. my pc isn't linked to the customer's network. Only some times (if I am at the customers firm) i can connect to their network. Additionally I have a remote access the their network.

I already have a split database. Only the data has to be replicated. I have the prg.mde and the repldata.mdb located on the customers pc's and one masterdata.mdb on the network.

Andy
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 12065273
Andy,

<<The original design master is located on a network drive at the customer. If I make changes, I copy the design master to my laptop, make this as new design master (because it is a replica then only), make my changes to the tabels, copy it back to the customer's network drive and then make this on again as the design master. Maybe this causes the corruption of the database ? >>

  You can do that, but you should sync up all the replicas before making that copy a design master once again.  I'm assuming your using recover Design Master to change the status?

  A better approach would be to move a replica with Replication Manager to your site.  Once that's done compact the current design master and synch all replica's.  When you synch, check the "Make <database> design master" checkbox against your replica.

<<If this is not a good way, what is the best way to make changes "offline" >>

  I generally make changes on a customer MDB via remote access.  I rarely take anything off-line.  Too much chance of a MDB getting corrupt.  If I do transfer, I always zip so I get CRC checking on the file.  At least that way, if there is a copy error, I'll know about it.

<<Another thing that is not really clear to me is: what exactly is a replica set? I understand it as a group of databases (1 design master and n replicas). BUT: When is a replica set created>>

 A replica set is started when you have a MDB open and select "Create Replica" on the menu for the first time.  

<< and how can I move a databse to another location ?>>

  Use Replication manager, file/Move replica

Jim.
 

Jim.
0
 
LVL 4

Author Comment

by:cas1
ID: 12066703
Jim,

<< You can do that, but you should sync up all the replicas before making that copy a design master once again.  I'm assuming your using recover Design Master to change the status?>>

How can I do that ? If let say 10 People are using the database, they are seldomly all connected to the network at the same time. Maybe one person is in vacation for weeks. So I can't sync up his replica. Or am I wrong ?

So Jim,

in my situation, what would you do ? Obviously the database is corrupt somehow and the replicas are deleted. Should I import all tabels to a complete new database and make a new replica set on the customer's network ?

Andy
0
 
LVL 57
ID: 12066871
Andy,

<<How can I do that ? If let say 10 People are using the database, they are seldomly all connected to the network at the same time. Maybe one person is in vacation for weeks. So I can't sync up his replica. Or am I wrong ?>>
 
  No, your understand is correct.  But the standard practice is synch everything before you change a design master.

<<in my situation, what would you do ? Obviously the database is corrupt somehow and the replicas are deleted. >>

  All the replicas are gone?  

<<Should I import all tabels to a complete new database and make a new replica set on the customer's network ?>>
 

 Yes.

Jim.
0
 
LVL 57
ID: 12066888
BTW, if these users are/will be laptop users connecting from the road, I'd use indirect sync rather then direct.

  What happens here is a file of the changes passes to a dropbox on the users machine, then gets sync locally.
0
 
LVL 4

Author Comment

by:cas1
ID: 12072338
Thanks for the informations about replication. Hope, setting up a new database will fix my problem

Greetings

Andy
0
 
LVL 57
ID: 12073356
Andy,

  Please let me know if you need additional help.

Jim.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now