William Hindman
wdhindman at bellsouth.net
Tue Sep 23 19:12:59 CDT 2003
David/Steve ...as a long time user of Citrix I can't avoid jumping in here with a couple comments :) ...Citrix is basically a superset of W2K Terminal Server on a WAN ...net or dial up, both work quite well ...in fact the core code of TS was bought from Citrix a couple of years back and has replaced a lot of the original Citrix functionality. ...its great software, relatively pricey to implement but inexpensive to maintain ...will do everything you want and once setup requires minimal client maintenance ...updates are all done from the central server ...client printers are very easy to connect as long as they're PnP compliant ...its best if you spec a standard printer though or they'll drive you nuts trying to tweak reports to match every printer variable. ...if your client can afford it, Citrix sounds ideal for your stated needs ...you just keep right on writing Access code as you do now and Citrix handles the rest ...once setup you'll find the maintenance to be a breeze and your client will love it. ...clients sometimes balk at the upfront costs but the TCO is actually less than a web based app over time considering the high development, maintenance, and upgrade costs of a custom web app. ...HTH :) William Hindman So, then, to every man his chance -- to every man, regardless of his birth, his shining golden opportunity -- to every man his right to live, to work, to be himself, to become whatever his manhood and his vision can combine to make him -- this, seeker, is the promise of America. -- Thomas Wolfe ----- Original Message ----- From: "Steve Capistrant" <scapistrant at symphonyinfo.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Tuesday, September 23, 2003 7:50 PM Subject: RE: [AccessD] Web based Project > There are several variations of the "client", but most the most typically > used one is internet based. So yes, they use their browser, and log in to a > secure site, and then are presented with a remote desktop (so they have a > remote desktop within their local desktop). > > Reports CAN be printed on their own printers, but that is one of the > settings that you have to make special for each user. Some of our clients > who use Citrix can handle this setup themselves, but others rely on a Citrix > vendor to handle these advanced settings. > > The other thing that's nice is that you can load Word, Excel, Outlook, etc. > on the Citrix server, allowing your Access app to interface with them as > well. Still without requiring that those products be loaded on the client > machine. This is why it is called "thin client" computing. Although the > local machine could still have those apps locally loaded as well. > > Steve Capistrant > Symphony Information Services > scapistrant at symphonyinfo.com > www.symphonyinfo.com > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Emerson > Sent: Tuesday, September 23, 2003 6:16 PM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Web based Project > > > Thanks Steve, > > Do users access via direct dial or the internet? > > Can users print out the reports on their own printers? > > David > > At 23/09/2003, you wrote: > >Consider Citrix. You can keep your entire application in Access (or > upgrade > >the BE to SQL Server when the size grows too big). Users around the world > >download a small client on their machine, and access your system via remote > >control. They don't even need Access installed. Don't need an expensive > >machine. All the processing activity happens at the server, so the speed > is > >good. Web based databases are nice but cost a lot of money, and in the end > >you can't really reproduce many of the cool things we come to expect from > a > >LAN based application. If you want a referral to a good Citrix vendor, let > >me know. > > > >Steve Capistrant > >Symphony Information Services > >scapistrant at symphonyinfo.com > >www.symphonyinfo.com > > > > > >-----Original Message----- > >From: accessd-bounces at databaseadvisors.com > >[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Emerson > >Sent: Tuesday, September 23, 2003 5:44 PM > >To: accessd at databaseadvisors.com > >Subject: [AccessD] Web based Project > > > > > >Group, > > > >Over the past 3 years we have developed a database in Access 97 that > >basically accepts user input, runs some basic calculations and prints > >reports. There are about 50 screens and 230 reports. The users (about 20 > >- could rise to about 100 in two years) are all on stand alone machines > >spread throughout the USA. They are the only ones that would normally > >access their client records. Currently there are about 5,000 client > >records in total but this could rise in the next two years to 50,000. > > > >My client now wants to put it onto the web so that updates can be done > >easier and in one place (rather than needing to be distributed each > >time). Users can then access it through the Internet, add/change their > >client data and run off their reports. This is not a big corporate so > >budget is an issue. > > > >The client also doesn't have an IT department so the maintenance of any web > >server would be outsourced. > > > >I only have experience in Access (97/XP) and SQL2000. I have not done > >anything with web based databases. > > > >My questions - > > > >1) What options for an interface do I have using an Access or SQL back end? > > > >2) Is there another option for the BE that might be better? > > > >Regards > > > >David Emerson > >DALYN Software Ltd > >25b Cunliffe St, Johnsonville > >Wellington, New Zealand > >Ph/Fax (877) 456-1205 > > > >_______________________________________________ > >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 > > _______________________________________________ > 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 >