track changes (1 Viewer)

[maravinds]

Hallo Everyone,

I am working with the database that consists of more than 15 tables with more than 50000 records and the problem is that more than 10 people use the database. So in this case I am not sure whether who has the changed the data in it.

So for this reason i need to create a logfile to determine what are all the changes made in the data in the database with the user who uses that.
(I need to create a history and save it.)

is that possible in MS ACCESS? if so can anyone tell me some suggestion


aravind.s

 

[ColinEssex]

Search for 'Audit Trail'

GHudson has posted some superb examples

Col

 

[maravinds]

hai,

first of all, thanks for the reply but using the TRAILAUDIT() the database size increases rapidly. So in this case i need to store only the changes in a separate file.

it will be helpful if i get the alternate solution for this..


aravind.s

 

[RuralGuy]

Here is a solution I used some time back but I put the AuditTrail table was in a separate mdb. Creating an Audit Log