We have a database in the office which is constantly being updated by 26 
users.  We have a database on our web site which has an extract of the one 
in the office - this is used by our clients so they can see the status of 
their accounts without having to call us.  

Several times a day we create the extract database in the office and FTP 
it up to the web overwriting the one already there.  This works fine as 
far as it goes.  However the clients also want to enter data using the web 
site.  Now I have a problem.  I don't want to overwright the existing web 
database any more.

So it would be nice if I could see the web database on our network and 
update it using ASP code - and pick up any data the clients may have left.

How can I connect to both databases at the same time and so avoid having 
to FTP?

Ian