Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
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
Medium Priority
?
323 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 2000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
In this article, we’ll look at how to deploy ProxySQL.
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

571 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