cyphertoxin
New member
- Joined
- Nov 24, 2014
- Messages
- 2
- Programming Experience
- 1-3
Hi all, I'm a newbie to this forum so apologies if I've opened this thread in the wrong place.
I'm looking to create a kind of Knowledge Base application which will be located on a server and accessible by several people via a desktop shortcut to the exe located on the server. My question is, how do I handle the accessing and updating of database table records if two users, for example, decide to update a record at the same time? One person might open the record at the same time as the second person, and then they both decide they want to make different updates to that record before saving and closing.
I realise this question may be more relevant to a SQL Server forum, but I'm not sure about this either.
I have successfully created a full-on database application before (about 2 years ago) which used SQL Server as a back-end and vb forms up front for the GUI and interaction. It took me a while as I was on a learning curve, but I completed it and so am now fairly confident I can develop a decent program again, but I'm just not sure on the multi-user side of things.
Any help much appreciated.
Thanks.
I'm looking to create a kind of Knowledge Base application which will be located on a server and accessible by several people via a desktop shortcut to the exe located on the server. My question is, how do I handle the accessing and updating of database table records if two users, for example, decide to update a record at the same time? One person might open the record at the same time as the second person, and then they both decide they want to make different updates to that record before saving and closing.
I realise this question may be more relevant to a SQL Server forum, but I'm not sure about this either.
I have successfully created a full-on database application before (about 2 years ago) which used SQL Server as a back-end and vb forms up front for the GUI and interaction. It took me a while as I was on a learning curve, but I completed it and so am now fairly confident I can develop a decent program again, but I'm just not sure on the multi-user side of things.
Any help much appreciated.
Thanks.