Re: Can Access handle this configuration, or do I need SQL Server?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul Ponzelli (pponzelliREMOVE_at_ANTISPAMsurewest.net)
Date: 02/18/05 

Date: Fri, 18 Feb 2005 13:54:36 -0800

Thanks for the comments and the references, everyone.

Two additional questions:

1. Have any of you used a thin client for a production database over a wide
area network? If so, is it satisfactory?

2. I'm thinking that Replication could be problematic if there are
transmission interruptions over a WAN. I've also heard that Replication is
difficult to implement over a WAN even under the best conditions. Is this
true?

Thanks again in advance

Paul

Relevant Pages

  • Re: Can Access handle this configuration, or do I need SQL Server?
    ... If so, is it satisfactory? ... I'm thinking that Replication could be problematic if there are ... difficult to implement over a WAN even under the best conditions. ...
    (microsoft.public.access.formscoding)
  • Re: Replication vs log shipping
    ... Your problems all seem to stem from your WAN. ... I think you will find that log shipping is not really scalable. ... Well that depends on how you are using Data Mirroring. ... over the wire than other replication solutions. ...
    (microsoft.public.sqlserver.replication)
  • Re: replication topology
    ... 'other' sites for replication to/from each other? ... If there are alternative WAN Links then: ... KCC would treat the Site Links as transitivie Spoke-Hub-Spoke ... On the connection objects however, they appear to be configured to ...
    (microsoft.public.win2000.active_directory)
  • Re: replication topology
    ... 'other' sites for replication to/from each other? ... If there are alternative WAN Links then: ... KCC would treat the Site Links as transitivie Spoke-Hub-Spoke ... site is the hub site, and all the other sites spoke of it. ...
    (microsoft.public.win2000.active_directory)
  • Re: Domain over WAN
    ... deployment whereby the main concern was the cost of the WAN - it was ISDN. ... changing the default replication interval and localising ... I feel like a broken record, but in a WAN based AD deployment you will want to look at the number of users at each location and the size of replication for having a DC at the remote site. ... Once you have those numbers then you can determine whether there is less WAN traffic by having a local DC or by having your users authenticate over the WAN. ...
    (microsoft.public.windows.server.active_directory)