Showing posts with label user database in visual basic. Show all posts
Showing posts with label user database in visual basic. Show all posts

Sunday, November 16, 2014

Users Database Using Client - Server in Visual Basic 6

As a programmer majority of my applications that I have written before in Microsoft Visual Basic 6 is more on single user or one computer alone. As time passes by business applications should be network in order for many users can use the application efficiently and they where able process as many data as they can. 

The first time I heard the term Client - Server Architecture that first thing that comes up with my mind is that it is very difficult to learn or even to achieve in writing a program that has client-server capabilities. I do some extensive research and study and I was able to find out developing a database applications in Visual Basic 6 and Microsoft Access for client-server deployment is not difficult but easy if you know how to plan and implement your system properly.

The fist thing that we must do is to create a folder in our computer in our windows operating system. In my case I named the folder vb afterwards I share the vb folder in my network so that it can be accessed by other computer in the network. In this article I added some screen shoots to give up some idea how to share and configure your client and server side of your Visual Basic application.

In my client side of the application in my module in Visual Basic 6 I declare the following code to access the ms access database in the server computer.

Public Sub con()
cn.Open "Provider=Microsoft.jet.OLEDB.4.0;Data Source=\\10.0.0.2\vb\server3\user1.mdb; Persist Security Info= false"
rs.CursorLocation = adUseClient
End Sub


I hope this article gives you an idea how to write and develop a database system in Microsoft Visual Basic 6 and Microsoft Access Client-Server Database Architecture. If you have some questions please send me an email at jakerpomperada@yahoo.com and jakerpomperada@gmail.com.

You can text or call me here in the Philippines in the following mobile numbers 09173084360 and 09993969756.

Thank you very much and Happy Programming



Client Side Screen Shoot


Server Side Screen Shoot


Sharing of Folder in the Server Side I am using Windows XP for the Server