[AccessD] WANs and Access

I have considerable experience doing this. In one case I had 4 offices
hooked together in a WAN, all running the same Access app. That's when I
became an expert at Access replication. I put a copy of the BE on a server
in each office, that the local users talked to. In the HQ office, a box was
running Synchronizer and updated the branch BEs every 5 minutes, as I
recall. Thus the longest it could take for any remote user to see changes
made by a local user was 10 minutes. But even in the case of collisions,
Replication Manager handled them flawlessly.

This delivered much better performance than the straight WAN approach, which
I tried first and was very unsatisfied with the performance. Using
replication over the WAN resulted in much greater performance.

Arthur


On 4/6/07, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com>
wrote:
>
> I'll forward your name to the client.  He's in Canada.
>
> Rocky
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
> Sent: Thursday, April 05, 2007 11:16 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] WANs and Access
>
> Hi Rocky:
>
> If you need any help with setting up applications running at different
> locations I could offer some help in that area as I have definitely done
> enough of that type of work.
>
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
> Beach Access Software
> Sent: Thursday, April 05, 2007 10:09 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] WANs and Access
>
> Had a prospect ask me how robust my application would be running over a
> WAN.
> Broadband connection but 'slow' according to his description.  Plus folks
> dialing in from remote locations but at least 50MBPS.  Anyone have any
> experience with this or know of any limitations with Access in this
> regard?
>
> MTIA,
>
> Rocky
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.26/746 - Release Date: 4/4/2007
> 1:09 PM
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>