Error: "You can't modify the design of 'PAR' at a replica."

[gscott1]

Hello,

I want to add a column to an existing table which I would use to create some queries. When I go to look at the table in design view, I get a message saying "You can't modify the design of 'PAR' at a replica." I am only allowed to view it as read only. Why is this and what does it mean?

Thanks

[mshmyob]

I have never personally used the Access replication but you need to modify the Design Master and then synchronize all the other replicas. So in other words make sure you are modifying the Design Master.

Maybe someone else can shed some more light on the problem.

cheers,

Hello,

I want to add a column to an existing table which I would use to create some queries. When I go to look at the table in design view, I get a message saying "You can't modify the design of 'PAR' at a replica." I am only allowed to view it as read only. Why is this and what does it mean?

Thanks

[missinglinq]

I suspect that whoever actually developed this database doesn't intend for anyone to make any modifications. You probably need to speak to whoever that is within your organization.

Welcome to bytes!

Linq ;0)>

[ADezii]

Hello,

I want to add a column to an existing table which I would use to create some queries. When I go to look at the table in design view, I get a message saying "You can't modify the design of 'PAR' at a replica." I am only allowed to view it as read only. Why is this and what does it mean?

Thanks

I'm not skilled at Replication, but it appears as though you are attempting to make changes to a member of the Replica Set and not the Design Master. To the best of my knowledge, msymyob hit the nail on the head with his Reply.

1. Add the Column to your Table in the Design Master only.
2. Save the Table with the new Column addition, then:
3. Tools
4. Replication
5. Synchronize Now
6. The new change will be transferred to all Replicas in the Set
7. If you do not know what either one of us are talking about, I strongly suggest you consult someone who does know before doing any of the above.