convert replica

convert replica

Post by Robirdma » Thu, 30 Sep 2004 00:20:09


I tried to add a table to an Access 2000 DB, and it won't
let me as it says it is a replica.
There is no other version of the database that it is
synchronized to or anything. If there was an original it
has been deleted.
How can I make this a non-replica?
 
 
 

convert replica

Post by Brad Farre » Fri, 01 Oct 2004 02:54:33

There should be an option under tools, replication and then recover design
master. That will make that version of the database the design master.
Before you do this, I would recommend the following:

1. Create a backup copy of the database;
2. Ensure that you have replicated with all other copies of the database
that you need to.

Brad

 
 
 

convert replica

Post by cm9iaXJkbW » Wed, 03 Nov 2004 05:04:03


Convert design master is grayed out and non-selectable
 
 
 

convert replica

Post by Um9iaXJkbW » Wed, 03 Nov 2004 05:06:02


recover design master is grayed out and not selectable.
 
 
 

convert replica

Post by cm9iaXJkbW » Fri, 05 Nov 2004 00:13:02

Recover design master is grayed out and non-selectable. My problems always
seem to reach a dead end.
 
 
 

convert replica

Post by mich » Tue, 23 Nov 2004 02:45:03

If Access thinks its a valid replica and it is not the design master
already, then the option will not be grayed. If it is, then one of the prior
points will not be true.


--
MichKa [MS]
NLS Collation/Locale/Keyboard Technical Lead
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.
 
 
 

convert replica

Post by cm9iaXJkbW » Wed, 24 Nov 2004 01:22:33


All I want to do is add some new fields to a table. When I
try, I get the message that I can't make changes to a design replica.
But when I go to tools, replication, the only choosable option is make
replica, all else grayed out. So it seems that in one case Access thinks it
is a replica and in the other it does not. So what does this mean?
 
 
 

convert replica

Post by mich » Wed, 24 Nov 2004 16:33:53

Sounds like it is no longer a replica -- corruption perhaps?


--
MichKa [MS]
NLS Collation/Locale/Keyboard Technical Lead
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.




it

prior


always
 
 
 

convert replica

Post by cm9iaXJkbW » Fri, 26 Nov 2004 02:49:02

I have run compact and repair database multiple times with no problems
encountered.
Under replication, since the only choice available is "create replica", I
chose this to see what would happen. It says that in doing so it will make
the original a design master, shich is just what I wanted. When I proceed
though, then it says the very first table can't be replicated. If I choose
the "help" box, then nothing happens, so there is no explanation.
The first table only has 14 records with 5 fields. Changing data and
resaving has no effect when the whole process is repeated, I still get "can't
replicate object" in this table.
So, as stated before, in one case Access regards the database as a replica,
in another as a design master. Repairing has no effect. I can only conclude
that this is a very poorly designed buggy program that can't even tell what
the status of its database is. If it is corrupt, there is no evidence of it
in any of the tables, numerous quesries, reports etc. I just can't add any
new tables. STUPID!!!
 
 
 

convert replica

Post by cm9iaXJkbW » Tue, 07 Dec 2004 21:15:02

It appears that once again, as with almost all my problems, I have another
that totally stumps all the possibly knowledgeable people for month after
month, as the behavior of this program is totally inexplicable and does not
work as it is supposed to. I keep hoping that someone will know something
but I suppose that, as with so many others, I will probably just have to give
up and never be able to do what I was once able to.
 
 
 

convert replica

Post by UGF1bCBTYW » Tue, 07 Dec 2004 23:41:03

When all else fails, try creating a new database. Import all
forms/macros/reports/modules etc. Then create links from the new database to
the old database. Finally, use create table queries to copy the data fields
from the old database to the new database. Don't use "Select *" as that will
also copy the replication information and you will still have the problems
associated with a replica. You'll have to select each valid data field
individually in the query. After you've finished copying a table, delete the
link to the old table and rename the new table to the proper (old) table name.

Its tedious, but the only way to convert a replicated database to a simple
non-replica.
 
 
 

convert replica

Post by cm9iaXJkbW » Wed, 08 Dec 2004 21:43:02

This sounds so incredibly complicated. I did not understand all of your
post. You didn't say if I need to import the tables (57) nor queries (197).
I'll have to read up on creating links. Just one table has 27 data fields.
I can't imagine why it should be made so difficult and what is the purpose of
the "create design master" menu. I guess if I did it gradually over a period
of days it wouldn't be as terrible. I don't know when I'll have that much
time.
 
 
 

1. Converting replica mode server to autonomous mode

2. REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX

3. BREITLING DISCOUNT REPLICA BREITLING DISCOUNT REPLICA BREITLING DISCOUNT REPLICA BREITLING DISCOUNT REPLICA BREITLING DISCOUNT REPLICA BREITLING DISCOUNT REPLICA BREITLING DISCOUNT REPLICA BREITLING DISCOUNT REPLICA

4. Tiffany-replica Tiffany,Replica Jewelry,Tiffany Jewelry,Fake Tiffany,"Replica"+"Tiffany"--On sale

5. louis vuitton replica bags,louis vuitton replica purses,replicas louis vuitton

6. louis vuitton replica bags,louis vuitton replica purses,replicas louis vuitton,louis vuitton wallets

7. Seamaster Aqua Terra Replica Seamaster Replica Omega replica

8. knock off louis vuitton replica bags,louis vuitton replica purses,replicas louis vuitton

9. louis vuitton LV replica bags,louis vuitton LV replica purses,replicas louis vuitton LV

10. REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA R0LEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA R

11. REPLICA ROLEX REPLICA ROLEX REPLICA R0LEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA R

12. REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA R0LEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA R

13. REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA R

14. REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA R0LEX REPLICA R0LEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA R

15. REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REPLICA ROLEX REP