473,320 Members | 1,832 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Track changes

25
Hello,

I want to know if we can keep track of the changes done in the database.
e.g: I have a database called db1.mdb
This gets updated from an application say app1.
Now I want to keep track of the changes done in the db1.mdb without making any changes to app1.

Is this possible? and if yes then how?
Aug 9 '12 #1

✓ answered by twinnyfo

rupali,

You would have to track every edit done by the user, and store the table, field and change in a separate table, along with who changed it and when they changed it. What you are talking about is monitoring everything that goes on in your database.

Yes, it is possible to do this, however the effort required may not be worth the benefit.

The simplest way is to build a public function that writes to a separate table that only tracks changes. Every time a data field is updated, that function would fire, saving the table name, field name, data before, data after, who updated it and when.

There would also be ways of doing this looking at the dirty state of a form and cycling through all the controls to see if they have been updated.

Either way, it will require modifying all your forms and input interfaces so that everything trips this update tracking function.

Hope this gets you down the right track.

9 4468
ariful alam
185 100+
What changes about are you talking? Changes of Data (Insert/Edit/Delete) in tables or any other changes?
Aug 9 '12 #2
rupali
25
yes I want to track changes in data, if new data is inserted, or existing data updated or any deletions done.

Also the database I want to keep track changes is in MS Access.
Aug 9 '12 #3
twinnyfo
3,653 Expert Mod 2GB
rupali,

You would have to track every edit done by the user, and store the table, field and change in a separate table, along with who changed it and when they changed it. What you are talking about is monitoring everything that goes on in your database.

Yes, it is possible to do this, however the effort required may not be worth the benefit.

The simplest way is to build a public function that writes to a separate table that only tracks changes. Every time a data field is updated, that function would fire, saving the table name, field name, data before, data after, who updated it and when.

There would also be ways of doing this looking at the dirty state of a form and cycling through all the controls to see if they have been updated.

Either way, it will require modifying all your forms and input interfaces so that everything trips this update tracking function.

Hope this gets you down the right track.
Aug 9 '12 #4
rupali
25
Hello twinnyfo,

It means I will have to modify the entire application by inserting a record in new table with all the details you mentioned above.

But I want to ask is there any other solution using which I wont have to modify the current application.
I mean anything in MS Access which must be logging some info of the changes done.

To tell in more detail:
I want to synchronize the MS Access database and PostgreSQL database.
So I was searching if we can track changes in data in MS Access.
Aug 9 '12 #5
twinnyfo
3,653 Expert Mod 2GB
To my knowledge, Access does not keep track of anything like that inherently. You have to track it through code and store it somewhere.
Aug 9 '12 #6
rupali
25
Ok Thanks twinnyfo, for all your quick responses.
May be I will have to go by the solution you provided.

Thanks again.
Aug 9 '12 #7
zmbd
5,501 Expert Mod 4TB
Rupali,
Please do a search on this site... several threads cover this EXACT topic and offer some very good solutions.

-z
Aug 9 '12 #8
rupali
25
ariful,

You can answer me if you have any solution to my question.

Without making any change to current application,
can I get the changes done in the database in MS Access.
like SQL Server database has a transaction log that records all transactions and the database modifications made by each transaction. This is inbuilt feature of sql server.
similarly do we have anything in MS Access?
Aug 9 '12 #9
zmbd
5,501 Expert Mod 4TB
Rupali.

To answer your last question:
- no, you will have to make a change.
- there is no built in audit trail within access.
you must code it.

In addition to searching this website for various solutions to the audit trail question
Here's an example:
http://support.microsoft.com/kb/197592

-z
Aug 9 '12 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Danny Chok | last post by:
Hi I would like to know if there is anything to call up Word and perform a "Track Changes" function between two documents? How? Thanks a lot. Danny
1
by: JLuppens | last post by:
Does anyone know if there is a way to track changes in a text field like word does? I am using a SQL2000 database and can use either VB.Net or Access. The field is either ntext or Varchar. I...
4
by: Nicole | last post by:
Hello: I have a shared database running on a network drive. I would like to track when record changes occur and who did it. Problem 1: I'm not able to tack changes, when they occur in...
5
by: Colleyville Alan | last post by:
I have some data in a table structured like this: Date Cust_ID CUSIP Amount 01/31/2005 060208 02507M303 27,061.84...
1
by: mankolele | last post by:
Hi all Is there someway to track changes made to data in a mysql database? Like someone changes a phone number in a record on a form -Is there a way to find out what changes were made to what...
2
by: Luis Freitas | last post by:
I know how to track changes when they are done using a form. Can they also be tracked if I run an update query?
2
by: zoro25 | last post by:
Hi, I'm creating a database and I need to find a way to track the changes to a record, more exactly, I need to know who makes changes to each record, as the users can only modify their own...
20
by: John Sheppard | last post by:
Hello there, Does anyone know of a way to track changes to an SQL Server database so that I can easily run those changes at a later date? That is, I want to make schema changes, and record...
6
Plater
by: Plater | last post by:
As a quick setup: My company uses MS SQL SERVER 8 as a backend, and uses an old mdb/mde file as a frontend with linked tables. Lately we've been running into a problem where a particular entry in...
3
by: dirksza2009 | last post by:
Hi, I've made a multi user (4 end users) database in Access 2000. I've made data tables, reference tables etc which sits on a shared drive and I've made individual front ends for the end users...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.