I'm drawing a blank on the actual technique right now, but basically you can use an in-memory recordset that tracks the original values and the new ones. When you go to save the changes back to the database, it compares the current DB values against the original values, before applying the new ones. If they don't match, an error is generated. If they do match, it's safe to make the updates.
Andreas had the right answer on the refresh. I know there was a reason for that silliness, but now I don't recall what it was, other than some odd behavior from the MMC framework. Thanks, -Michael From: [email protected] [mailto:[email protected]] On Behalf Of Roland Janus Sent: Friday, February 27, 2015 11:35 AM To: [email protected] Subject: RE: [mssms] Multiple users accessing the MDT DB I guess the codeplex web page would need to deal with that also, some logic to handle that, which brings me back to the question, what could be done from a programmatically point of view to not get into some kind of mess? What would you suggest in general for that? Cheers, roland From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Michael Niehaus Sent: Freitag, 27. Februar 2015 11:06 To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Multiple users accessing the MDT DB The console is rather "passive" about multiple users. It should generate an error in case there are conflicting updates, but otherwise yes, you're going to see some odd behaviors with multiple users. My suggestion would be to use the web interface available on CodePlex if you want to have a simple GUI that works better with multiple users. Thanks, -Michael From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Roland Janus Sent: Friday, February 27, 2015 10:26 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] Multiple users accessing the MDT DB Is there advice on handle that properly? I've started the console twice, with the same user, added a dummy entry on the first console. One issue is that the 2nd console wouldn't show that entry. Refresh isn't doing anything. I had to close and open again. The same happens of course when entries are changed or added. Unless the other console is closed and open again it wouldn't show. Those two even showed different values for the same ID, depending on where it was changed. That of course can cause inconsistency and entries being overwritten. I don't plan to use the console anyway, but a powershell based GUI, with the MDT-module from Niehaus. Would I ran into the same problems, or how do I handle multiple users then? -Roland
