Replication issues

  • Thread starter Thread starter lkdenver
  • Start date Start date
L

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.
 
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
 
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
__________________________________________
 
Back
Top