Replicate/BE/FE or Append Qry

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!
 
lmv said:
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
 
Thanks for responding!

Tony Toews said:
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
 
Back
Top