[AccessD] Web based Project

Steve Capistrant scapistrant at symphonyinfo.com
Tue Sep 23 18:50:32 CDT 2003


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





More information about the AccessD mailing list