Solved

Need to add a column to MySql DataBase, where I can track the last user who made changes to the information.VB.NET

Posted on 2010-09-09
2
315 Views
Last Modified: 2013-12-25
I have a programm in VB.NET   that requires a correct log in, in order to access to it. Once the user has accesed to it, he can make changes to the information. I want to have a column where I can check who was the last that modified that information.


Thanks.
0
Comment
Question by:zandizza
2 Comments
 
LVL 6

Accepted Solution

by:
DalHorinek earned 500 total points
ID: 33642294
I guess you have an id of your users. So add a column last_id_user to the information table and on every change do something like

update information_table set last_id_user = <id_of_current_user>

Maybe I don't understand well the question.
0
 

Author Comment

by:zandizza
ID: 33642304
yes, that is exactly what I am looking for. To set a record of everyone who has update information.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question