bruce_bruen at mlc.com.au
bruce_bruen at mlc.com.au
Tue Feb 10 19:37:31 CST 2004
Terry, Presuming : 1) that maintenance activity can only occur locally at a site (i.e Site 2 cannot perform Site3 work) 2) the 24hr delay remains acceptable 3) the offshore site is notr going to create timezone problems. I would go with a more traditional approach, giving each site its own local BE and provifing and end of day routine that copied new/changed data back to a separate static analsys db. "MACE, Terry" <terry.mace at baesystems.co To: "'AccessD at databaseadvisors.com'" <AccessD at databaseadvisors.com> m> cc: Sent by: Subject: [AccessD] Database Operation from Remote Sites accessd-bounces at databasea dvisors.com 11/02/2004 11:40 Please respond to Access Developers discussion and problem solving 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