Replication issues

[lkdenver]

I am a novice at DB development so I could use any help I can get. I am
creating a large DB with allot of Documentation info, ie: Doc name,
date, rev date, title, text of standard, laws, owners, Co name and much
more. I had created this Db on my laptop at first then replicated it to
the share drive. I am the only one using this DB at present. So now
when I try to change any tables, queries etc, the program won't let me.
An error comes up with stating: "You can't modify the design of the
table or query at replica. Design changes can only be made at Design
Master. Open read only?y/n" Should I just delete these tables or
queries and start creating them again? Help please..I have a upcoming
deadline too. Thanks for any help ahead of time.

 

[Larry Linson]

Replication is not for the faint of heart; nor is it for casual use. It
seems clear that something you have done has left the computer you are using
(want to use to change design) as a replica, with the design master
elsewhere. It's not even clear to me why you felt you should use
replication; it's not just a way to back up your database. And, it is for
certain, that to change the design, you have to do so in the design master
of a replicated environment.

Unless there is a very good reason for replicating (e.g., there is going to
be a central master DB and multiple users going out with notebook computers
without a connection and they have to synchronize with the master DB), I
suggest you go to groups.google.com and search for posts on how to disable
replication and recover your database.

Larry Linson
Microsoft Access MVP

 

[Guest]

Hi lkdenver,

What goal did you have in mind when you implemented replication? I'm
wondering if you did so for the correct reasons. I am not a replication
expert, but I do advise you to download a copy of the replication white paper
from Microsoft:

ACC2000: Jet 4.0 Replication White Papers Available in MSDN Online Library
http://support.microsoft.com/?id=190766

Here is a KB article that may also be helpful:

ACC2000: How to Make a Database Replicable
http://support.microsoft.com/?id=208774

Although both titles include "ACC2000", the information should be equally
valid for Access 2002 and 2003. I would also head on over to Michael Kaplan's
web site and read everything you can find on replication:

http://www.trigeminal.com/usenet/usenet.asp?1033



Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________