Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Vermont
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replication opinions

    I have an application in which users need to take part of the database off line, occasionally swap records with one another (off line), and eventually end up with one big happy consistent database. I'm looking at use MS Access replication for this but have never used it.

    Is replication a good idea?

    Will it do what I need?

    Is there a better way?

    Thanks for all your thoughts.

  2. #2
    New Lounger
    Join Date
    Nov 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replication opinions

    This is a good article for Microsoft info: Q282977 - ACC2000: Microsoft Access 2000 Replication FAQ Available in Download Center

    I only fooled around with replication once and I had problems but we were making changes to the design. If the database schema is fixed, I understand it works well.

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    Vermont
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replication opinions

    Thanks. I got the low-down on the theory, anyway from the follow MSDN article; it's a good introduction from the ground up, but since I haven't done anything but the simplest possible test, I don't know if it leaves out anything one would really want to know:

    http://msdn.microsoft.com/library/te...n_replicat.htm

    There's also:

    http://msdn.microsoft.com/library/techart/dbrepjet.htm which I think covers much of the same ground, updated for Jet 4.0

    I'm still a little nervous about staking a customers entire (if relatively small) app on this technology, though.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Replication opinions

    Partial replication is pretty much the only way to do what you're describing, although I don't understand your reference to swapping records off-line. Look up partial replication in on-line help and download the partial replication wizard from the MS site.
    Charlotte

  5. #5
    New Lounger
    Join Date
    Jan 2001
    Location
    Vermont
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replication opinions

    Thanks for your note; yes, partial replication seems like the way to do it too. w/r/t swapping records off line, the main database is back on the lan, but user1 ends up with records for clients Joe, Sally, and Bill. Part way through their site visit, user1 realizes that they have to pass the work regarding Bill off to user2. I'm hoping they can synchronize with the appropriate options and have user2 end up with records about Bill.

    While all this sounds good in theory, I'm still hoping someone here will write the magic words: "I use replication and it works." I'll feel much better then [img]/w3timages/icons/smile.gif[/img]

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Replication opinions

    The problem isn't whether it works, the problem is whether it works the way you want it to. I'm not sure partial replicas can with other partial replicas, but I can't recall, since I never used this particular approach. Your safest approach is to always sync back to the hub replica your partials were created from. That way, all the data is there for any of the partials to sync to.

    Replication works quite well, but it does require maintenance and you will have to rebuild the design master at some point, so plan on it. Just put this mantra on your wall: "You cannot sync design AND data changes". Repeat it everytime you feel the urge to violate it, because otherwise your rebuild of the design master and all child replicas will take place sooner rather than later.
    Charlotte

  7. #7
    Star Lounger
    Join Date
    May 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replication opinions

    Charlotte,

    Do you mean:
    You can sync design OR
    You can sync data
    but not concurrently.

    or do you mean:
    You can sync data but never design.


    Later.....
    Sorry, having read the rest of the posts about replication I can see what you mean is:
    Make sure you don't force replication of design and data at the same time because Access loses the plot when it tries to sync data in fields which no longer match up.

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Replication opinions

    You got it right in the end. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Charlotte

  9. #9
    hotbudare
    Guest

    Re: Replication opinions

    I've been working with replication for almost a year now, and have never had a problem WHEN I'VE THE THE THINGS RIGHT AND IN THE RIGHT ORDER.
    In general, I think replication is the next best thing to a LAN/WAN, but you really have to do your homework and read a lot. Check the following links:
    <A target="_blank" HREF=http://www.trigeminal.com/usenet/usenet005.asp?1033>http://www.trigeminal.com/usenet/usenet005.asp?1033</A>
    <A target="_blank" HREF=http://www.trigeminal.com/usenet/usenet008.asp?1033>http://www.trigeminal.com/usenet/usenet008.asp?1033</A>
    <A target="_blank" HREF=http://www.trigeminal.com/usenet/usenet008.asp?1033>http://www.trigeminal.com/usenet/usenet008.asp?1033</A>
    <A target="_blank" HREF=http://www.trigeminal.com/usenet/usenet006.asp?1033>http://www.trigeminal.com/usenet/usenet006.asp?1033</A>
    <A target="_blank" HREF=http://www.trigeminal.com/usenet/usenet013.asp?1033>http://www.trigeminal.com/usenet/usenet013.asp?1033</A>
    <A target="_blank" HREF=http://www.trigeminal.com/usenet/usenet014.asp?1033>http://www.trigeminal.com/usenet/usenet014.asp?1033</A>
    <A target="_blank" HREF=http://www.trigeminal.com/usenet/usenet017.asp?1033>http://www.trigeminal.com/usenet/usenet017.asp?1033</A>
    <A target="_blank" HREF=http://www.trigeminal.com/usenet/usenet003.asp?1033>http://www.trigeminal.com/usenet/usenet003.asp?1033</A>
    <A target="_blank" HREF=http://www.trigeminal.com/usenet/usenet027.asp?1033>http://www.trigeminal.com/usenet/usenet027.asp?1033</A>

    <img src=/S/book.gif border=0 alt=book width=15 height=15>
    Edited by Charlotte to activate URLs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •