JWColby
jwcolby at colbyconsulting.com
Thu Apr 5 13:18:42 CDT 2007
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