I'm currently working on a project for Uni, and I've come across a really 
annoying blip in the work.

We've been given a semi-functional Access 97 database, and we have to get 
up and running proper, and I'm having trouble when it comes to eliminating 
all the bugs.

When I open either the master, or the replica, I'm told that there is a 
data error in one of the replica set, and that it needs to be resolved.  
When I click 'data error', it tells me that there are 6 data errors in the 
switchboard, 3 in the replica database (replica.mdb), and 3 in a database 
that doesn't exist - although it probably has in the past (temp 
database.mdb)

After checking the details, the only thing I can see wrong is that some of 
the switchboard items are incorrect under one of the menu's, even when 
I've changed their details using the switchboard manager, and by modifying 
the table which stores the switchboard by hand.  (an example is that one 
of the items is called 'Display Contacts' in both the manager, and the 
table, but on the form, it still displays the old 'Edit/Add Contractual 
Staff')

My knowledge of replication in access is limited to say the least, and 
I've heard that people have had all sorts of problems with it, so is this 
just another problem with Access Replication or have I done something 
wrong.

If anyone can give me any advice on this, I'd be more than appreciative.

Not sure about 97, but I'm guessing that a 'Data Error' means there is a
CONFLICT in the data stored in two copies of the database.

i.e. A record was changed in one replica, and the same record was changed in
another replica, in-between synchronisations.  The master therefore doesn't
know which one to use, so it defaults the the one according to the listed
priority until you confirm which one it should use.

In Access 2000+ there is a little applet called 'Conflict Manager' to help
us recolve these conflicts.  There are actually a number of improvements to
replication after 97 which obvisouly isn't a help to you..

This site has an excellent replication section that may be of use:
http://www.trigeminal.com/resources.asp?2057

He also has his own 'synchronizer' which works with Access 97 and has many
features that are unavailable through native Access.

Cheers,
Andrew

-----Original Message-----
From: Scott Hawkins [mailto:scott.hawkins@t...]
Sent: Thursday, 19 December 2002 10:34 PM
To: Access
Subject: [access] Replication problems


I'm currently working on a project for Uni, and I've come across a really 
annoying blip in the work.

We've been given a semi-functional Access 97 database, and we have to get 
up and running proper, and I'm having trouble when it comes to eliminating 
all the bugs.

When I open either the master, or the replica, I'm told that there is a 
data error in one of the replica set, and that it needs to be resolved.  
When I click 'data error', it tells me that there are 6 data errors in the 
switchboard, 3 in the replica database (replica.mdb), and 3 in a database 
that doesn't exist - although it probably has in the past (temp 
database.mdb)

After checking the details, the only thing I can see wrong is that some of 
the switchboard items are incorrect under one of the menu's, even when 
I've changed their details using the switchboard manager, and by modifying 
the table which stores the switchboard by hand.  (an example is that one 
of the items is called 'Display Contacts' in both the manager, and the 
table, but on the form, it still displays the old 'Edit/Add Contractual 
Staff')

My knowledge of replication in access is limited to say the least, and 
I've heard that people have had all sorts of problems with it, so is this 
just another problem with Access Replication or have I done something 
wrong.

If anyone can give me any advice on this, I'd be more than appreciative.

IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.