Cannot save table - replication error

[Guest]

I have made a change to a table within my database which resides on my
company server. In attempting to save it, I get an error "You cannot make
changes to the design of the database at this replica".

When I go to Tools/Replication, everything is greyed out except "create
replica", so I have nothing to "sync" to.

How can I resolve this issue?

 

[David W. Fenton]

I have made a change to a table within my database which resides
on my company server. In attempting to save it, I get an error
"You cannot make changes to the design of the database at this
replica".

When I go to Tools/Replication, everything is greyed out except
"create replica", so I have nothing to "sync" to.

How can I resolve this issue?

Where is the design master of the replica set? Table changes have to
be made in the design master.

 

[Guest]

The two people in my office that utilize the database access it off of our
server. I assumed it was the design master copy. If it isn't, can we
designate it as such?

 

[David W. Fenton]

The two people in my office that utilize the database access it
off of our server. I assumed it was the design master copy. If it
isn't, can we designate it as such?

Well, you *can*, but it would be better to make a significant effort
to find the real Design Master. If you branch the replica set to
have two Design Masters, any replicas from the old DM won't be able
to synch with the replicas for the new DM after a certain point
(i.e., after even one design change has been propagated).

 

[Guest]

The only thing that I can think of is I used to have a copy of our database
on my Tablet PC in a briefcase which I syncronized. I deleted that file
because, using small business server, I can still have access to the data
anywhere I have an internet connection.

I don't think it was, but maybe that copy I deleted was the design master.

 

[David W. Fenton]

The only thing that I can think of is I used to have a copy of our
database on my Tablet PC in a briefcase which I syncronized. I
deleted that file because, using small business server, I can
still have access to the data anywhere I have an internet
connection.

I don't think it was, but maybe that copy I deleted was the design
master.

The DM would be whichever database you initiated the briefcase
replication from.

Sounds to me like you don't need replication at all.

* Access 2002 instructions (should work for A2003, too)
http://support.microsoft.com/kb/290052/

* Access 2000 instructions
http://support.microsoft.com/kb/208394/

There are two other tools that also work for Jet 4 databases:

* Michael Kaplan's TSI Un-Replicator Add-in
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7

* Graham Search's Unreplicate Utility
http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm