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

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • gscott1
    New Member
    • Feb 2008
    • 7
    #1

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

    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
    Tags: None
    • mshmyob
      Recognized Expert Contributor
      • Jan 2008
      • 903
      #2
      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,

      Originally posted by 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

        Comment

        • missinglinq
          Recognized Expert Specialist
          • Nov 2006
          • 3533
          #3
          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)>

            Comment

            • ADezii
              Recognized Expert Expert
              • Apr 2006
              • 8834
              #4
              Originally posted by 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
              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.

                Comment

                Previous template Next
                Working...