[AccessD] WANs and Access

If the location with the file server has workstations with Windows 2003, you
can use remote desktop, at least two instances per computer.  Thus if the
client already had people inside that location (with windows 2003) running
the app, then another user could remote in to their machine and use the db.
They would have to have their own account etc.

Remote access is IMHO definitely the way to go, whether TS or other.  As
William says, disconnects will corrupt the database if the FE is running
remotely. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: Thursday, April 05, 2007 2:08 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] WANs and Access

...unplanned disconnects, even momentary, are the bane of any file server db
system ...in my experience Access and WAN requires a Terminal Server or
Citrix implementation to be both reliable and fast ...not to say it can't be
done otherwise but that my experience with such sucks because disconnects
are almost inevitable ...however, if you do go the TS route, your Access app
can actually be faster in the user's view even though he's hundreds of miles
away.

...btw, if you do look at this route, Citrix costs more than TS but their
support is a whole lot better imnsho and well worth the extra bucks. TS in
the mean time, is actually an older version of Citrix that MS licensed and
has done some work with.

William Hindman

----- Original Message -----
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Thursday, April 05, 2007 1:09 PM
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