Is it a productive and good idea to program my VB Application to make transactions to the SQL server within our company, instead of passing through a server first?

This application has the potential to go outside of our company, and be used by others, who would need access to that SQL server.

I'm not looking for code here, just good advice on this? How should I approach?