I am creating a business software package in visual basic.net that will handle invoices, quotes, purchase orders, inventory items, customers, etc. This program is multi-user meaning that different people could each be running an instance of the program on their computer, with each instance modifying a central database. The problem is that one instance of the program could for example add a new inventory item, then how would I make the other instances of the program update their inventory lists to recognize the change? The program works with a dataset that it stores locally to avoid extra calls to the central database, so how do I tell the program when to update its local dataset in one instance when another instance of the program made a change to the central database?
I hope that didn't confuse anyone. Any help is appreciated, I love examples :)
Jump to Post
Well, since I don't have much of your code, I'm going to throw a few concepts at you. I'm not sure how your network works, or if you are comfortable with the idea... but think of this.... you could create a server program that sits on the same computer as …
Jump to Post
that's a good place to start.... if you need any help with it, just post, or let me know.... I'll see what I can't do.
All 8 Replies
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.