MACE, Terry
terry.mace at baesystems.com
Wed Feb 11 17:48:53 CST 2004
Drew, thanks for your info so far. I would like to see the in and out of how to create something if that is not too big an ask, but any info would be good. Terry Mace -----Original Message----- From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com] Sent: Thursday, 12 February 2004 09:53 To: accessd at databaseadvisors.com Subject: RE: [AccessD] Database Operation from Remote Sites By sample/demo, do you mean a complete in and out look at how to create something, or just a working ASP interface? Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Helmut.E.Kotsch at t-online.de Sent: Wednesday, February 11, 2004 12:45 AM To: Access Developers discussion and problem solving Subject: AW: [AccessD] Database Operation from Remote Sites Good morning, where could I find a sample / demo for the ASP approach? Regards Helmut Kotsch -----Ursprüngliche Nachricht----- Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von DWUTKA at marlow.com Gesendet: Mittwoch, 11. Februar 2004 02:43 An: accessd at databaseadvisors.com Betreff: RE: [AccessD] Database Operation from Remote Sites ASP is a very good approach for multi-site systems. The real question is how complex is the data entry? If you are only talking about a few forms, then ASP is the way to go. Have Site1 host the ASP pages, with the db on their network. That would allow for no modifications necessary for the data mining process. However, if the data entry is very complex, you may want to go with a Citrix/TS approach. More costly to initially implement, but no real 'development' would be required. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MACE, Terry Sent: Tuesday, February 10, 2004 6:41 PM To: 'AccessD at databaseadvisors.com' Subject: [AccessD] Database Operation from Remote Sites Hi all, I'm after some information on the best way to proceed with the expansion of an existing Access97 database application which is used for maintenance activity recording. My company currently runs this database at two sites, call them Site1 and Site2. The BE is changed at Site2 as a function of its operations, each night the BE is copied to Site1 where it is used for admin and data mining purposes with the data acknowledged as being up to 24hrs out of date. This has served the company well up to now as only one site can change the data. The company now want to expand the number of sites that use and i/p data. The new layout will have at least 4 sites. Site1 will be the admin and data mining centre, Site2, 3, and 4 will i/p and change data. Sites 1, 2, and 3 are on a WAN with Site3 being the companies main site and hosting the companies Internet gateway. Site4 is overseas and not on the WAN. What I would like is some idea of the best approach - I have read a bit about replication and ASP but have no practical experience with either. Thanks for any assistance. Terry Mace Logistic Support Officer & Maintenance Supervisor BAE SYSTEMS 677 Victoria Street, Abbotsford, VIC 3067 Ph: +61 3 9208 0924 Fax: +61 3 9208 0588 Mailto: terry.mace at baesystems.com <mailto:terry.mace at baesystems.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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com