Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Replication (Acess2000)

    Is it possible to use replication to keep forms, queries, reports, and modules updated? And if so, to what extent? For example, does it extend down to individual objects on a Form? For example, suppose2 people made changes to a form (let's say each changed the location of a different control); would the 2 forms then be "synched"?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Replication (Acess2000)

    Hi Mark,
    The general concensus is that using replication to distribute design changes is not the best strategy in most situations. The preferred approach seems to be a split database where the front-end is updated to individual workstations via the LAN, email, or sneaker-net, and to replicate only the data or back-end part of the application. A couple of resources that you might want to look at in detail are ACC2000: Microsoft Access 2000 Replication FAQ Available in Download Center and ACC2000: Jet 4.0 Replication White Papers Available in MSDN Online Library. Both seem to suggest that if you do take that approach, then you should distribute your design changes from the design master, but warn that there are reports of replicas not being fully updated after being synchronized. In addition, a form, query or report is considered to be an object from a replication perspective, so if two user changed the same query or report, you would get a replication conflict. You might also want to look at Trigeminal Software's website as they have a number of resources related to replication.

    We use replication only occasionally, and nearly always in what I call an occasionally connected network. If people want to be able to make their own queries and reports, we have them use a separate database from the application that we create, and we update the application on each user's hard drive when we make a design change. Hope this helps to put things in perspective - perhaps others can share different experiences.
    Wendell

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Replication (Acess2000)

    Wendell,

    Thanks for the links. This is a situation I may or may not become involved with. To not split the databases and rely on replication to update the objects is already a warning flag for me. This will force customers to transmit their entire databases back to a central site to be updated! Seems like a ridiculous use of time. So I'm wondering what other nonsense I might have to put up with. I hate to forego a possible new source of income, but I've also come to realize in my old age that often money doesn't make up for aggravation!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Replication (Acess2000)

    I agree that the situation looks pretty suspect. There are times when you just need to say "Hey, I'm the expert here and if you don't want to heed my advice, then I don't need your business!" There's the old saw that says the customer is always right, but at the same time you have a moral responsibility to give them the best advice that you can.
    Wendell

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Replication (Acess2000)

    Tough decision. My gut is telling me don't do it. But VISA, MasterCard, Bank Of America, and a few others disagree!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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