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