I created a program for one of my clients which uses a back-end MS Access database with a front-end VB.net application that allows the user to enter details into various tables, search through the information already stored there and lastly, generated various reports based on specific criteria.
My client has now asked me to extend the program so that it can perform all the tasks they require. The most important criteria is that their employee's must be able to use the program concurrently on more than one terminal and any information one adds, reflects on all other terminals.
An example of the kind of thing they need is like in a retail environment: There are two computer terminals that can both perform sales transactions. The terminals show how many of a specific item there are in stock. If Employee A makes a sale, the number of that particular item in stock decreases, and must reflect on Employee B's terminal.
I've never done anything like this and was wondering if someone could give me suggestions on how to do it and where to start.
Any help would be greatly appreciated.