Hello,
I have posted a question related to this problem before but I never got the full understanding of the concept. I would really appreciate if someone could help me, my deadline for the design of the project is in 2 days and I'm still having doubts :(
The system I'm developing is a VB/ASP.NET web application connected to a MS SQL Server Express.
The requirement is to be able to view a report that shows actions performed on all the tables in the database.
For example, I have an Item table. Whenever an Item is inserted in the table, in the report, I want the user to be able to see the user Id of the person who added the Item + action + date time.
I have many other tables such as Department, Transaction, Item Type which also I want to keep track of the actions performed on them.
I know that I have to add a History table that will store all this, but the question is, should I add a table for each entity (Department History, Transaction History, Item Type History) ?
I've read this article on how to approach this problem using Triggers:
http://www.4guysfromro lla.com/webtech/091901-1.shtml#postadl ink
But I'm still not sure of the number of tables that should be added.
Please help :)
Thanks
0 1430 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Evelyn Pabón |
last post by:
Hi
I'm developing a database with access and I was ask to include in the report
the date of issue. But if the date of issue was change It should be
included in the footnote area the issue date that was originally was written
and by who. And as if it was changed several times it should be included as
well.
How can I include this historical tracking in the report?
|
by: Dan Greenblatt |
last post by:
I am writing some software that, among other things, needs to track
the state of database tables. This includes occasionally checking the
table to see what records or added, modified, or deleted. The added
and modified parts of this have not proven too difficult to implement,
but is there an easy/elegant way to determine what records have been
deleted from a mySQL table ??
I'm very to mySQL, and after reading through the docs about logs,...
|
by: MUHAMAMD SALIM SHAHZAD |
last post by:
dear respected gurus,
I would like to share ideas...as i learned from you and wish to tell
that i had developed the system where i can audit each and every users
and their actions(like add/edit/save/cancel/unco)
=======================start of
modules=======================================
Option Compare Database
Option Explicit
|
by: fred tate via .NET 247 |
last post by:
I'm working on a project that will track a great deal of data forindividuals and will keep track of users for a very long time (5- 10) years. I'm looking for options as far as tracking anddisplaying changes to the data. Any suggestions for both the UIand the Data Storage aspects of tracking long term changes todata would be helpful.
Fred Tate
--------------------------------
From: fred tate
-----------------------
Posted by a user...
|
by: anony |
last post by:
Maybe this feature is already out there.
I guess you could write triggers to do some of this.
Often when designing a database I add a start_date and end_date column
to the table. The start_date is when the record was created and the
end_date is when the record expired. For UPDATES, I populate the
end_date and INSERT a new record. This allows you to track changes
though out time.
I do this so often I thought it would be a good idea for...
| |
by: DFS |
last post by:
One of my systems grew exponentially - from 13mb to 43mb - after adding some
10 temp tables (with no data), a new form, and about a thousand lines of
code. The .mdb has mostly table links, lots of forms and queries, and a
good bit of code overall.
But 43mb is totally unreasonble. I can't figure out where the problem is
occurring. It was fine for a long time. I even created a new file and
imported the objects and it blew back up to...
|
by: nyathancha |
last post by:
Hi,
I have a question regarding best practices in database design. In a
relational database, is it wise/necessary to sometimes create tables
that are not related to other tables through a foreign Key
relationship or does this always indicate some sort of underlying
design flaw. Something that requires a re evaluation of the problem
domain?
The reason I ask is because in our application, the user can perform x
|
by: David |
last post by:
On Wed, Jun 18, 2008 at 11:16 AM, M.-A. Lemburg <mal@egenix.comwrote:
Thanks for your reply.
How do you maintain foreign key references with this approach?
eg, you have these 4 tables:
table1
- id
|
by: sharsy |
last post by:
Hello,
I have setup an Access Database which about 7 people can enter data
into. We have had a few problems where a 'fairy' has mysteriously been
changing data in the table that they're not supposed to. I was
wondering if it was possible to find out which user is responsible for
making these changes. The database is not password protected or
anything.
Kind regards,
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |