Converting Stand-alone Application To Network-based(client-server)

The data source or reference will change to the location of the server hosting your database. I am making the assumpting that you are use a relational database system i.e. MS Sql, Oracle or MySql?
Your connection manager will manage concurrent users and connection pooling. You will have to watch out for multi-user updates on your database records

Hi Dynast,

In your application you should have a connection object similar to dim cn As New ADODB.connection
cn is your object that set it's properties.
Provider,Security, catalogue and server.

As the application is deployed to each machine, each user's machine will know how to connect to the database server.
Each connection will allow the user to perform the database tasks as defined in your application. It is as simple as that.
If you really want to make things easy and the application will run over a domain, use an alias for the database server which can be resolved via DNS so you do not have to go to each machine if you need to change the location of the database server. i hope this make sense?

Let me know if you need more help

Thanks Ayinkus
how do I make use of alias.I'm not quite conversant with that . I ll be glad if u will add more flesh to that

Thanks very kindly Ayinkus
I  have a stand alone software developed in VB and now I want to use it in a network ENVIRONMENT hence i neeed to restructure it so that it will be suitable in network environment to accept data from clients and store in a central database

You'll have to change your queries to support concurrency ,

like SELECT FOR UPDATE ,

or use tricks like optimistic concurrency , where you compare the record to be updated with the record before the update ,  if they're different , then the record has changed etc.

Its not exactly trivial but you'd need to ask yourself what the impact of concurrent users would do to your app, the impact might not really be much ,

have fun