[AccessD] WANs and Access

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