Can't change tables in database

[Chris]

Our database used to be Replicable, but after doing a compact and repair it
removed this feature. No great loss. This made the Design master a standard
database. The problem is that when I try to add some columns in any of the
tables it says I can't because it is a replica. There is no design master
any more, as the database I am trying to change used to be the design master.
Can anyone help me solve this issue?

 

[Joan Wild]

Tools, Replication, Recover Design Master.

 

[Chris]

Thanks, but the only option available is 'create replica'.

 

[David W. Fenton]

Thanks, but the only option available is 'create replica'.

It's unclear which file you're working with. If the DM has lost
replicability, it should allow you to make changes, and you should
see only "create replica" as an enabled choice on the Replication
menu.

If, on the other hand, you're working from one of the replicas,
those would disallow design changes, and you should be able to
recover the DM.

It sounds like your situation is the former one, but that's not
normal. You may want to try running an Unreplication tool. There are
two of them that work with 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

The latter has code, and you could perhaps learn something by
reviewing the code, but I've never actually used the latter (I've
hardly ever unreplicated anything).

 

[Chris]

Thanks. This looks very usefull. Problem is that our system doesn't allow
these sort of downloads, so I'm going to try at home.

Thanks for the reply