How to make an multi-user application in VB6.0?

[premMS143]

How to make multiple instance of an application

We have created a application using VB as front end & Access as Back End.
That application was installed in Server & permission given to a single user
for the data entry.


Now our Manager's idea is to use/access that VB application 3 persons at a time.Is it possible to access the application more than 1 user at a time to read, write data to the same MS Access table...?

Or to do this, what are the methods/Codes to get it.


Please help me...

[debasisdas]

that depends on how the application is handling the database.

[EYE4U]

Hope this application is a networking application and the three persons will use the application from 3 different computers.
If yes then you need to do some thing like multithreading... if you dont knw how to do multithreading in vb there is another way to handle this thing...
Create a program in vb which will handle all transactions or operations on database. Create an exe of the program. Now every time a user logged in to do work on database your server will execute the exe file which is handling the database for online users.
After executing connect your client applications to those exe you have runned for them...
Now all three or any number of clients can do work simultaneously on database.

If you need an example tell me i ll made one for you...

Regards
ARUZ

[debasisdas]

you can run multiple instance of the same exe but you might need to make some changes to database path and moreover the way the application handles the database to manage isolation level.

[premMS143]

To,
Eye4U

Yes Sir,
I need an example with sample code.
Could you help me. Please..


Thanks
Prem

[EYE4U]

Prem
In my example i ave just given the idea to how to manipulate your scenario. In this example you can create as many as users and can Add and can Search in the database.
I have not apply the networking in it.
If you want networking it ll a bit more job. If you dont get the example in right you can contact me to get help in networking in this app.

Regards
ARUZ

[premMS143]

@EYE4U
ThanQ Mr. Aruz.
It's really great helpful.

[Gastone Katebe]

Thanks so much Mr Aruz.... first i got the vb program you created on a multi user system . now i need your help on networking part.. i need codes or sample.

[e-mail]

Thanks in advance