Unanswered: Trackin user activity with a secure DB
Here is the problem.
A secure DB has been used for some time now. Each user has to login in order to work with the DB. Now it has been discovered that some records have been updated without changing the RecordID. The records do not have Date() or Time() when they have been created. My questions are:
1. Is there any way to retrieve only records modifies by a specific user?
Keep in mind that currently the DB does not have any designated field attached to the records that uses the function Currentuser().
2. Can I identify records that have been modified after they have been created?
I guess I am asking for the impossible, but you guys may come up with some brilliant idea that could save me tons of time.