Developer Forum

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?

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 design master is grayed out and non-selectable

recover design master is grayed out and not selectable.

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

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.

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?

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

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!!!

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.

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.

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.