[AccessD] Database Operation from Remote Sites

DWUTKA at marlow.com DWUTKA at marlow.com
Tue Feb 10 19:42:45 CST 2004


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


More information about the AccessD mailing list