BE sync 1 direction

L

lmv

I have a problem. I am using MsAccess 2003 I don't have a replication
"manager" I don't have a developer copy of access... I have read one way sync
can be done with code.

Someone deleted over half of the records (500) in a specific table. I want
to be able to one way sync the db so I don't loose all of those deleted
records in the master copy. But I want to update all of the changes that were
made in the db other than that...

I have read and I have some code but I seem to be missing instructions on
HOW to do it.

Where do you put the code and how do you run it? Thanks!
 
D

Damian S

Hi lmv,

If the person who has deleted the 500 records (presumably in their
replicated copy) does NOT sync, deletes their replicated copy and replaces it
with a copy of the current master copy, you will not lose the 500 records,
but you will still lose the other updates that have been made by that user.
All other users should be unaffected by this method.

Hope that helps,

Damian.

<insert disclaimer here about advice destroying your database and/or life>
 
Top