connie.kamrowski at agric.nsw.gov.au
connie.kamrowski at agric.nsw.gov.au
Tue Sep 23 18:56:33 CDT 2003
David, We use Citrix as an extension to our corporate system. Our users can use a direct dial in secure ID or access via a citrix web based client. Users can print from their own printers and have access to all components of the database, there are specific settings for Citrix printers etc. On a personal note for my university course I am in the process of writing a web based application for an assignment which will run on an access data base. You may find this page interesting http://msdn.microsoft.com/library/default.asp?url=/archive/en-us/dnaraccgen/html/msdn_jobforum.asp Connie Kamrowski Analyst/Programmer Information Technology NSW Agriculture Orange |---------+------------------------------------> | | David Emerson | | | <davide at dalyn.co.nz> | | | Sent by: | | | accessd-bounces at databasea| | | dvisors.com | | | | | | | | | 24/09/03 09:15 AM | | | Please respond to Access | | | Developers discussion and| | | problem solving | | | | |---------+------------------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> | | cc: | | 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 This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient or received it in error, please delete the message and notify sender. Views expressed are those of the individual sender and are not necessarily the views of their organisation.