Re: Replicated records losing data - partially

Tech-Archive recommends: Speed Up your PC by fixing your registry

plese don't be fullish things in the world will be mizreble so going to
crazyness will can not be a solution for the matter. Think before decide!
<maria@xxxxxxx> wrote in message
news:1120783630.971751.213640@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I am going crazy! I have a client who has been using my MSAccess
> application for MANY years. We have a split db with a data mdb in the
> main office, a hub replica, a design master and several remote data
> mdbs that use indirect synchronization. Everything has worked fine for
> more years than I care to think UNTIL last month. Now they tell me
> that they have begun noticing that some (but not all) of their changes
> have been disappearing. A record that had a change to a text field
> (phone number) and a memo field (notes) will LOSE the phone number
> change but KEEP the note change. Sometimes a text change stays and a
> Yes/No field reverts. Sometimes SOME of a memo field stays and the
> rest disappears. I can't even imagine HOW this could be accomplished.
>
> Three things to note:
> 1. Someone added a laptop replia which they sync with the office mdb
> AND NOT the hub replica. How does Access handle THAT situation?
>
> 2. I looked at the generation fields (GEN_MemoFieldName fields) and
> the generations are all the same in a given record which doesn't seem
> right. Shouldn't the gen of each memo field reflect how recently it
> was changed?
>
> 3. They cut from websites and paste into their db but they swear they
> go through Word and unformat everything.
>
> ANY IDEAS would be greatly appreciated!
> - Maria (Retired Access consultant, desperately wanting to re-retire!)
>


.

Relevant Pages

  • Replicated records losing data - partially
    ... We have a split db with a data mdb in the ... Sometimes SOME of a memo field stays and the ... Someone added a laptop replia which they sync with the office mdb ... I looked at the generation fields and ...
    (microsoft.public.access.replication)
  • Re: Saving a array of bytes using ADO
    ... Let's say table have a qry and Memo field called MEM_FLD ... >In TADOQuery component there is no way of saving an array of bytes. ... If I manage this for mdb I think I can use the same technique for other DB using ADO components. ...
    (borland.public.delphi.database.ado)