Problems with synchronization

[Jonathan]

I have benn working with Access for about a month.

I have a design master and two replicas located on a
network drive. My staff have copies of the replicas on
their local hard drive. They enter data into the replica,
at the end of the day they copy that replica to the
network where I synchronize it with my design master so
that the separate data is accumulated.

My databse is built of three levels of tables with one
table at the top (collection records), one table in the
middle (unit records) and a series of tables at the
bottom (material records, or data on stuff within the
units). The connections are one to many relationships.

For the past two days, while Access says that I have
synchronized with the two replicas successfuly, the
design master is only receiving updated information from
the collection records table, and not the lower level
tables. For two or three weeks before that everything
seemed to be working right.

Would this be caused by an unresolved conflict? (I can;t
find any.) Would it be the result of some security issue
preventing the transfer?

I hope that the solution is simple and apparent and just
some oversight on my part.

Jonathan

 

[Gary Miller]

Jonathan,

If you are having conflicts in the synch process you should
be getting warning messages alerting you to them. I am not
sure what your problem may be, but a question or two.

1) Do you have referential integrety being enforced on your
table relationships?

2) Is the whole database replicable or just the Back End?
Just the Back End is what is recommended.

3) Are all of your Autonumbers set to be GUID types to avoid
any potential conflicts?

FYI - If this isn't any help, there is a replication
specialty group at microsoft.public.access.replication that
has some fine gurus donating their time to help.

Gary Miller

 

[John Nurick]

Hi Jonathan,

I'm not a replication expert but I believe that copying replicas from
place to place can cause trouble. See
http://www.trigeminal.com/usenet/usenet009.asp?1033