I am planning to convert a vb6 application that uses access 2000 and ado to vb net 2010 or later. I want the basic converted vb net program to run on a remote web site or on a local desk top. Looking for the best data base using ado to use in the new vb net program. The application will be a distributed system to a customer base that subscribes to our software, now written in vb6 using access 2000 and ado. Vb6 has access 2000 built in so that the end user is not required to have access 2000 installed. Hopefully this would work the same with vb net 2010 with some version of SQL.
Any help here is appreciated. Also any comments on using vb net as the development tool is appreciated. It is my understanding that I will need to purchase Visual Studio 2010 since vb net 2010 that needs to be run on a web site is not sold stand alone.
I realize that I am asking multiple questions here, but just want to select the best tools to develop the net version of our product.
Thanks for any help.