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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server live connection & Synchronization...

Status
Not open for further replies.

svu

Programmer
Apr 10, 2000
30
TH
Dear Sir/Madam,
I'm very new to development using ASP & VB + backend as ACCESS 2000 or SQL SERVER 7. I have certain queries to make. Kindly take time for my request.
1. Is it possible to have my database on a webserver and to connect to it using a desktop application developed in VB. It simply means a direct live connection to the web-based database from a local computer.( kindly tell me the way for Access 2000 & SQL server separately)
2. I'm developing a ecomm website with a order processing module in it using ASP. I want a way by which I can synchronize my web & local copy of database. I can make changes to either of the data and then synchronise again to update both the copies. But only the new and/or updated records travel the wire making the process extremely fast. ( kindly tell separate solutions for ACCESS 2000 & SQL SERVER).

Thanking you in advance.

Regards,
Shirish
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top