Steve Capistrant
scapistrant at symphonyinfo.com
Tue Sep 23 17:59:33 CDT 2003
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