[AccessD] WANs and Access

The best approach for them is to set up a Terminal Services box in the
office and have them log into it. It can run the Access app which in turn
talks to a BE residing on another server. That way they get maximal speed
and they are talking to the HQ database.

On 4/7/07, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com>
wrote:
>
> Were the remotes doing updates, then?  Or read only?
>
> In this case the remotes will be traveling, signing in from hotels and job
> sites and such.  So I suppose they could run the replication ad hoc?
>
>
> Rocky
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
> Sent: Saturday, April 07, 2007 7:47 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [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
> >
> --
> 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/750 - Release Date: 4/6/2007
> 9:30 PM
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>