[AccessD] Database Operation from Remote Sites

Hi Terry

A possible solution would be the NeTraverse Terminal Server:

  http://www.netraverse.com/products/wts/

Of course, the remote office will need some kind of Internet
connection.

It will offer your app a Win98 environment for each user.
License cost for WTS and Win98 will roughly be USD 250 per user.

/gustav


> 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>