AW: [AccessD] Database Operation from Remote Sites

Have a look at this free software site, lots of help and tutorials
http://www.genericdb.com
It works as a basic ASP config page (setup database connection 
string,etc) then you run a series of asp wizards to view your database 
tables.
and create your need asp pages.
It has an added benefit It is multilingual.


Helmut Kotsch wrote:

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

-- 
Marty Connelly
Victoria, B.C.
Canada