Replication: Alternatives?



Good day,

I am ?just? starting to familiarize myself with ?Replication?, and wish to
validate some concerns.

A client wishes to have a ?Main? database on a LAN that will be updated by 4
different users, each with a laptop, and each with a copy of the database (or
at least the relevant fields). The database has yet to be designed, however,
I anticipate the number of tables (and relationships) to be anywhere between
6-10.

The hitch however, is that for security reasons, the laptops cannot be
connected to the LAN.

Based on a post on http://www.trigeminal.com/usenet/usenet009.asp?1033 which
states:
?PURPOSE OF REPLICATION: To have two or more copies of a Jet database that
are always considered one synchronization away from being identical. Multiple
people can make changes in multiple databases but in the end everyone will
reach "convergence" and will be the same. The support is for connected and
occasionally connected users... but not FOR disconnected users. Microsoft Jet
replication does not support the scenario where you do not have a true direct,
indirect, or internet connection. Period.? I get the impression that
replication is not really an option in this case.

If this is the case, what other alternatives do I have?

Thank you for your time

Denis Bisson

--
DenBis
*Smile, it makes people wonder what you're up to....*

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-replication/200512/1
.



Relevant Pages

  • Re: Replication: Alternatives?
    ... > copy of the database. ... > cannot be connected to the LAN. ... If they can *never* be connected to the LAN, replication is ... single point of connection between the LAN and outside the LAN. ...
    (microsoft.public.access.replication)
  • Re: Transaction Error on None-Transaction Query
    ... Create database connection ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Type ConnectionStringData is not defined.
    ... The typical code that establish database connection and perform command ... ' Create the Database object, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Replication ...on wireless LAN?
    ... you were ranting and raving about how 'Jet Replication is 100% flawless' ... and now you say that if a wirless connection is dropped then it CORRUPTS ... synch opens the remote database across the wire. ...
    (microsoft.public.access.replication)
  • Re: Errors in Directory Service Event Viewer
    ... >condition persists then please restore the database from a previous backup. ... >following directory partition. ... >Sites and Services for the KCC to create a spanning tree replication ... >- Add a Connection object to a domain controller that contains the directory ...
    (microsoft.public.windows.server.active_directory)