MS Access Tracking Record Changes Q

[-=XQ=-]

Does Access keep it's own list of changes to records. The database in question does not store changes to records using any custom features. Some data has been altered recently and it would be beneficial to find who changed the info and how.... Does anybody know whether Access would store this sort of information, if it does, where/how would you locate it?

Many Thanks

-=XQ=-

[M Owen]

Not that I know of ... I use a rudimentary LastModified field to do the same thing within each table ... It won't work for deleted records (for obvious reasons) ...

[MileOut]

Access does NOT store this information. The only information you'll get is the LastUpdated property of an object (table, query, form, etc) from the MSysObjects system table.

You are suggesting the creation of an audit trail. I don't have time to post an example but you'll find loads of threads on the subject on this site: Access Programmers.

[-=XQ=-]

Disappointing, but much as expected really... I personally do use the same approach as M Owen keeping my own fields usually named lngEntered and lngChanged... that links to a users table. In this case a colleague has asked if there is anyway of confirming who altered certian data in a rather basic access database.

Somebody had mentioned to me about hidden temporary information that Access stores, which backs up deleted data and stays present until the database is compressed. I think I have misinterpereted what I was told and the information must relate to the MSysObjects table that MileOut mentions.

Thank you very much for the info guys.

-=XQ=-