Vb 6 program on lan

Closed
vasu - Sep 15, 2009 at 07:39 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Sep 17, 2009 at 06:03 PM
Hello,

I have done a simple program when i add records to the employee table (Created in MS Access) The programing language is VB 6.0.

No I want to convert to LAN, when many people add to the same database

Please guide me how to update the current program.
Related:

1 response

sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Sep 17, 2009 at 06:03 PM
look at this link
https://sbpoley.home.xs4all.nl/tech/access-security.html

what you would need to do is create a front end and back end.
the front end will be what is on each workstation that users see and enter data, the backend will be the main database with all the tables etc on a 'server' the frontend will update the backend.

all is explained in the above link.

further info
https://stackoverflow.com/questions/221995/front-end-for-ms-access-migration
https://www.pcreview.co.uk/threads/access-front-end-sql-backend.1678202/
0