I have an Access 2000 database that I need to replicate over the web with a SQL7 master. I am using a VB6 program for entering data into the Access 2000 replica. What ActiveX controls do I use to establish a dial up connection and synchronize the data? Is there some sample code somewhere? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Replication over web
- Thread starter dslaby
- Start date
seyed
Programmer
Hmmm. Not entirely sure whether there is something more specific but heres a couple of ways I can think of:<br>
<br>
1. Ensure the SQL7 database uses TCP/IP and create a DSN entry on the machine with the Access database. Then simply use ADO to perform the synchronisation from your VB app (make sure you have the latest microsoft data components).<br>
<br>
2. Use Winsock and create a server application that listens for socket connections. Then have your client app contact the server and send the records over and have the server update the SQL database.<br>
<br>
3. Use Access to view the SQL database and transfer data as you would with any access table.<br>
<br>
1. Ensure the SQL7 database uses TCP/IP and create a DSN entry on the machine with the Access database. Then simply use ADO to perform the synchronisation from your VB app (make sure you have the latest microsoft data components).<br>
<br>
2. Use Winsock and create a server application that listens for socket connections. Then have your client app contact the server and send the records over and have the server update the SQL database.<br>
<br>
3. Use Access to view the SQL database and transfer data as you would with any access table.<br>
- Status
