David Emerson
davide at dalyn.co.nz
Tue Sep 23 18:15:31 CDT 2003
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