VB.Net Windows App - SQL Server Multiple Users
Posted on 2004-09-08
Here's my issue:
I've designed an app where there 2-3 people using the same program at the same time, accessing the same data. It works great for the most part. The problem is, I have one person (plant) who runs the program all day - so on the entry screen the same data sits in the dataset, the user adds records - isn't allowed to change older records. However, I have another user that goes in, checks the data that they enter, then verifies the record. Once it is verified the plant user cannot change the record. But since they don't close down the program the old (non verified) entry is still in their dataset. So sometimes they go back and change a record that has been verified already. Therfore screwing up the data.
1)So is there a way that I can refresh the dataset every half hour without screwing the user up in the plant - meaning, they could have a record they are in the process of adding and if it refreshed while they were doing this it would be traumatic?? The plant users are VERY computer iliterate
2) Would it be better if they see no previous data when they start up, and then they can add and edit the records they added. But how could I do this without changing a whole bunch of code???
3) Any other suggestions???