Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / May 2007

Tip: Looking for answers? Try searching our database.

Replication ...on wireless LAN?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lmv - 17 Feb 2007 05:48 GMT
Do you have to be wired or can it be wireless LAN to use Direct Replication?

So, if you have 2 laptops can you make a replica set wireless to the other
laptop?
And then sync? Or do you have to get into this complicated indirect
replication to do this? I am so confused! And what if you have Office 2003
not 2000 or XP...???
The directions are so complicated it will take me a month to figure this out!
Thanks! ;(
David W. Fenton - 18 Feb 2007 03:22 GMT
> Do you have to be wired or can it be wireless LAN to use Direct
> Replication?

There's a difference between what you *can* do and what you *should*
do. A wireless LAN may have sufficient bandwidth to make a direct
synch feasible in terms of time, but because of the extreme
unreliability of wireless connections (which tend to constantly lose
and regain signal), it is not advisable to do a direct synch over
wireless, just as it's not advisable to attempt to use table links
connected to a back end across a wireless link.

> So, if you have 2 laptops can you make a replica set wireless to
> the other laptop?
> And then sync? Or do you have to get into this complicated
> indirect replication to do this?

You can *do* a direct synch, but it's dangerous, because a direct
synch opens the remote database across the wire. If the connection
drops while that remote database is open, you will corrupt the
remote database and likely lose replicability, which means the
remote database is no longer part of the replica set and can't be
synched. That means you'll end up having to manually recover the
data in it and then create a new replica to replace it.

> I am so confused! And what if you have Office 2003
> not 2000 or XP...???
> The directions are so complicated it will take me a month to
> figure this out!

For a one-time synch, the risk is minimal across wireless. For a
regular synch operation, I would not recommend it as it's simply too
dangerous. The time and cost of implementing indirect replication is
completely worth the effort when compared to the time and cost of
recovering from corruption/loss of replicability (and don't forget
the downtime involved during that recovery).

Signature

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

lmv - 18 Feb 2007 03:36 GMT
Once again... thanks for the explanation!

> > Do you have to be wired or can it be wireless LAN to use Direct
> > Replication?
[quoted text clipped - 31 lines]
> recovering from corruption/loss of replicability (and don't forget
> the downtime involved during that recovery).
Aaron Kempf - 04 May 2007 21:02 GMT
and I've never corrupted a database when a connection drops

it sounds to me like your jet crap is well-- crap

seriously kid

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
THAT DATBASE?

David why don't you go and take a long walk off of a short pier

> Once again... thanks for the explanation!
>
[quoted text clipped - 33 lines]
> > recovering from corruption/loss of replicability (and don't forget
> > the downtime involved during that recovery).
David W. Fenton - 04 May 2007 23:40 GMT
> 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 THAT DATBASE?

Aaron, you're lying here once again, as I've never posted in any
public forum (or private) any assertion that could be interpreted to
even suggest that "Jet Replication is 100% flawless."

If I'm wrong on this, you can post a URL that points to the place
where I've made that statement.

But you cannot do that, because I've never done it.

YOU ARE LYING, AARON.

Please go away.

Signature

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

Aaron Kempf - 04 May 2007 21:00 GMT
David

STFU Access MDB is for retards

Don't blame it on the network
blame it on the database

MDB is for lamers and retards

Move to SQL Server and use Access Data Projects

I use ADP over VPN, WAN and Wireless every day of my life
without a problem

> > Do you have to be wired or can it be wireless LAN to use Direct
> > Replication?
[quoted text clipped - 31 lines]
> recovering from corruption/loss of replicability (and don't forget
> the downtime involved during that recovery).
David W. Fenton - 04 May 2007 23:39 GMT
> STFU Access MDB is for retards

If that is so, I'd expect *you* to be using it.

Signature

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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.