Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Replicate/BE/FE or Append Qry

Discussion in 'Information Technology' started by lmv, Jul 28, 2006.

  1. lmv

    lmv
    Expand Collapse
    Guest

    We have no network (at this point) so I have 3 or possibly 4 people that will
    work on the database. They will "probably" only be inputing info into 2
    tables. Orders and Order details.

    What is the best way to distribute this to the different users AND to be
    able to synchronize the information after users input new orders (back to a
    master). I have tried reading the options but I find it confusing because of
    the constant possiblity of corruption not knowing which jet/version of access
    etc is on each computer. Should I just do an append qry when I get their
    copies sent to me and then redistribute the master or ???

    Any input would be appreciated I have read the replication group / numerous
    articles and posts. But, if someone could just give me an answer in light of
    my scenario. Thanks!!
     
  2. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    lmv <lmv@discussions.microsoft.com> wrote:

    >We have no network (at this point) so I have 3 or possibly 4 people that will
    >work on the database. They will "probably" only be inputing info into 2
    >tables. Orders and Order details.
    >
    >What is the best way to distribute this to the different users AND to be
    >able to synchronize the information after users input new orders (back to a
    >master). I have tried reading the options but I find it confusing because of
    >the constant possiblity of corruption not knowing which jet/version of access
    >etc is on each computer. Should I just do an append qry when I get their
    >copies sent to me and then redistribute the master or ???
    >
    >Any input would be appreciated I have read the replication group / numerous
    >articles and posts. But, if someone could just give me an answer in light of
    >my scenario. Thanks!!


    There are going to be so many problems that could possibly occur you
    should put in the network. Life will be so much easier.

    Alternatively yes, an append query with a lot of fiddling would work.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  3. lmv

    lmv
    Expand Collapse
    Guest

    Thanks for responding!

    "Tony Toews" wrote:

    > lmv <lmv@discussions.microsoft.com> wrote:
    >
    > >We have no network (at this point) so I have 3 or possibly 4 people that will
    > >work on the database. They will "probably" only be inputing info into 2
    > >tables. Orders and Order details.
    > >
    > >What is the best way to distribute this to the different users AND to be
    > >able to synchronize the information after users input new orders (back to a
    > >master). I have tried reading the options but I find it confusing because of
    > >the constant possiblity of corruption not knowing which jet/version of access
    > >etc is on each computer. Should I just do an append qry when I get their
    > >copies sent to me and then redistribute the master or ???
    > >
    > >Any input would be appreciated I have read the replication group / numerous
    > >articles and posts. But, if someone could just give me an answer in light of
    > >my scenario. Thanks!!

    >
    > There are going to be so many problems that could possibly occur you
    > should put in the network. Life will be so much easier.
    >
    > Alternatively yes, an append query with a lot of fiddling would work.
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
    >
     

Share This Page