I don't believe that Access tracks this automatically, so you have to implement this yourself. For new or removed records you could check each table's record count at startup and compare them at shutdown, for modified records you would have to add some code on each form's AfterUpdate event saving information to a table.


>Hi All,
>
>I have been working on a MSAccess Accouting software. I want to know which tables have been updated after I have finished a particular functionality like Entering Invoice, Creating SO Order etc.
>
>By sorting by date the tables are sorted by either modified or created but the modified sorting means that the tables "field" have been modified and not whether any new data has been modified or added in the table.
>
>What my problem is that I want to know which tables has been added/modified with row/rows when I finish a particular function of a software. The longer method is to go through the code and see which tables are getting affected.
>
>Wouldn't it be beautiful if like in VFP, you can sort the tables which has been modified/added with new data according to the time and know which tables are getting affected with a particular funcionality?
>
>Does any one has deviced a way out to this kind of problem in MSAccess ?
>
>Thanks in advance!
>
>Sincerely,
>
>Sid