will switching design master lose data?

P

path1

I have no access experience but have figured some things out by poking
around, please tell me if what I'm contemplating is a good idea or not.

I need to make a minor change to the table of a simple access database
that was created by an intern 2 years ago and has not been modified
since. I located the design master but can not make any modifications
to it, nor can I find a way to change the permisssions (choices grayed
out). There are replicas which have all the current data in them, the
design master has none. It looks what I could do is set one the
replicas as the new design master, make the necessary change, and
synchronize it with the other replicas. Then we would have the
modified database replicas and a safe new design master all with
current data. Is this a good way to go or could it have horrible
consequences? Thank you.
 
P

path1

Is there a better option for making a small modification to table when
the design master can't be modified?
 
T

Tony Toews

path1 said:
I need to make a minor change to the table of a simple access database
that was created by an intern 2 years ago and has not been modified
since. I located the design master but can not make any modifications
to it, nor can I find a way to change the permisssions (choices grayed
out). There are replicas which have all the current data in them, the
design master has none. It looks what I could do is set one the
replicas as the new design master, make the necessary change, and
synchronize it with the other replicas. Then we would have the
modified database replicas and a safe new design master all with
current data. Is this a good way to go or could it have horrible
consequences? Thank you.

I'd suggest asking in the replications newsgroup. I think that's
where the replication experts hang out.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top