View Single Post
  #17  
Old May 31st, 2010, 03:50 PM posted to microsoft.public.access
Thomas Kroljic
external usenet poster
 
Posts: 21
Default Remote Database and Office Database

David,
Again, Thank You very much for your time and advice. I do appreciate.

Thomas

"David W. Fenton" wrote in message
36.99...
"Thomas Kroljic" wrote in
:

One final question for now, if the Field laptop is only used
for
gathering New data and there is no
reason to upload data from the Office database to the Field
database, is
it worth setting up a Replication procedure?


I don't know. If you are sure that's all that ever happens, and the
table they are adding data to is completely independent of all
others (no relationships), then it might be simpler.

But, frankly, writing the code to do that takes a lot longer than
writing the replication synch code, and replication will work even
if the requirements change and you need more than just one-way
additions, while "manually" updating will break if the requirements
change.

I'm prejudiced on this, i.e., pro-Replication, because I've been
using it for apps just like this since 1997. It's trivial for me,
and I've got pre-written code I can borrow from other projects to do
all the conflict checking and so forth (though none of it is all
that complicated).

In terms of reliability, as long as the synchs are always across a
wired LAN connection, it will be rock-solid.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/