I hate to say it but im my opinion this subject is way beyond what could
resonably be answered here, and without a better understanding of your
infrastructure and data needs it makes it even more difficult.

All I can do is to point you towards looking at using ADO w/ASP and possibly
SQL Replication. Again, your explanation is a bit sketchy so I am not sure.

Sorry i could not be more help.


Donald C. Burr, CIO
Nationwide Auction Systems
13005 Temple Ave.
City of Industry, CA 91746
Direct:  (xxx) xxx-xxxx
Cell:  (xxx)xxx-xxxx
dburr@n... <mailto:dburr@n...>


-----Original Message-----
From: shahid [mailto:ejaz@v...]
Sent: Saturday, February 15, 2003 10:23
To: professional vb
Subject: [pro_vb] Updating online Database using VB6


Hello Friends,
I have one sql sever database on web, one at head office and one at
franchisee end...
I need to know how to do following things :

AT FRANCHISEE END
The franchisee database gets updated frequently (this is done by simple
data entry). Now the difficult part is that on the click of button it
connects to the internet and updates the database which is on the web with
new datas entered. How do I do this ???

AT HEAD OFFICE
Head office too has a local database. On click of a button it updates its
local data with whatever is on the database on internet. I dont know how
do I do this ???

The data structure of the database at franchisee end, head office and on
the internet is same. All of them are sql server 2000 database.....

Now for the second difficult part....
At franchisee end and headoffice end...there is a multiuser
environment....how do i implement multiuser thing in my software and
database

I am using Visual Basic 6 and SQL server 2000...I am a newbie in SQL
server and VB too....can any one please help me how to implement the above
things.....
Thanking you in advance.....
Shahid