Hi Folks.. I'm constantly using the web in the past to write programs that only two or three people would use.. However, I use a web host to do hosting so I use the web a lot because the host has SQL server.. and I need it.. So, I'm wondering the following:

Since SQL server is hosted on an IP address, can I use VB Express as the front end, and SQL Server 2005 at my host as the backend and it work via the web / TCPIP as long as the client is on a network or has a web connection? I mean, shouldn't VB when doing the connection to SQL server not care where SQL server is, as long as it's using TCPIP which I'm assuming is by default, and has an IP address to get to the SQL Server? Sorry if that's a dumb question. The reason I ask, it seems to me that the interface would be easier to use for some that don't use the web, and I could build a typical VB app Frontend but stil have the power of SQL server on the backend.. Is this dumb, or should I just use VWD Express which I also have?